is of course the table. The field should then be 'id-User'.
The line is then probably
Code:
SELECT `ID-Kurs` FROM `#__comprofiler_place_user_wd` WHERE `ID-User` = '[user_id]'
What has changed is that the suggestions for the input field come from the other table. Which I don't want at all.
Above all, the result from the external table
CB Query Field can output multiple rows as a list if that's what you're asking. To do this simply adjust your query so it returns more than 1 result and set "Output" to "Multiple Rows".
Beyond that I can't help you connect to and pull data from a database you made. I have no idea what the structure is or intended use. We do not provide custom coding assistance here. I can only provide simple examples. Below is another simple example for multi-row output.
Query:
Code:
SELECT `username` FROM `#__users` LIMIT 10
Output: Multiple Rows
Row:
Code:
<div>[column_username]</div>
The above will output the first 10 rows of the Joomla _users table and display their usernames.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
