SHOW MULTIPLE FIELD VALUES FOR LIST OPTION LABELS IN A MULTI- VALUE LIST FIELD USING ‘GET OPTIONS FROM MYSQL QUERY’ - Nov 7th, 2017


The task was to show the field values for both the 'presentation_date' and the 'presentation_title' for the option
labels in a multi-value list field that pulled information from the table 'all_presentations'.

In a post on the forum, Daryl Maximo, a programmer at Interactive Tools suggested that I could add two or more field
values for my list option labels by using "Get options from MySQL query (advance)" instead of "Get options from database
(advance)" and use CONCAT() to combine two or more columns.

Here’s the final query code:

SELECT num, CONCAT(DATE_FORMAT(`presentation_date`, '%b %D, %Y'), ' - ', presentation_title)
FROM `<?php echo $TABLE_PREFIX ?>all_presentations`
WHERE hidden = 0
ORDER BY presentation_date DESC



The materials on this web site have been created for use with CMS Builder content management software. CMS Builder software is published and licensed for use by InteractiveTools.com. Please contact Interactive Tools for information on the downloading of the software or the purchasing of licenses.


Terms of Service