Custom label in list selection box

3 posts by 2 authors in: Forums > CMS Builder
Last Post: November 23, 2015   (RSS)

By Daryl - November 23, 2015

Hi Jim,

You can add two or more field values for your 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. 
For example:

SELECT num, CONCAT(DATE_FORMAT(`date`, '%b %D, %Y'), ': ', title)
  FROM `<?php echo $TABLE_PREFIX ?>workshops`

Hope this help!

Cheers,

Daryl Maximo
PHP Programmer - interactivetools.com

Daryl,

You're my new hero. Thanks so much. This worked perfectly.

Jim

WebCamp One, LLC



Websites That Work