Get options from MySQL query

4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 15, 2008   (RSS)

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!
Dave Edis - Senior Developer
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

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