Get options from MySQL query
4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 15, 2008 (RSS)
By sjenko - September 15, 2008
Hi I am wanting display more than one item from a specific table using the "list" option, I have selected the "Get options from MySQL query" and have enter this into the form filed "SELECT summary, title, date FROM cms_news". The results are only bringing back the first entry "summary", what else do I need to change to show all resluts "summary, title and date"
Thanks
Simon
Thanks
Simon
Re: [sjenko] Get options from MySQL query
By Dave - September 15, 2008
Hi Simon, welcome to the CMS Builder forums! :)
Only the first two columns returned are used. The first column is used as the list option value and the select as the label.
How do you want the list field to look (what values displayed) and what should it store in the database when selected?
Let me know and I'll try and help!
Only the first two columns returned are used. The first column is used as the list option value and the select as the label.
How do you want the list field to look (what values displayed) and what should it store in the database when selected?
Let me know and I'll try and help!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com
Re: [Dave] Get options from MySQL query
By sjenko - September 15, 2008
Cheers Dave I have solved the issue from a previous thread using:
SELECT CONCAT_WS(" ", related_title, summary), CONCAT_WS(" ", related_title, summary) FROM cms_news
to pull different information from the database.
Regards
Simon
SELECT CONCAT_WS(" ", related_title, summary), CONCAT_WS(" ", related_title, summary) FROM cms_news
to pull different information from the database.
Regards
Simon
Re: [sjenko] Get options from MySQL query
By Dave - September 15, 2008
Great, glad it's working. You obviously know some MySQL! :) That was the next thing I was going to suggest.
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com