Create pick list from multiple fields

Hi Tim, 

If you edit your list field, and change the field type to "Get options from MySQL query". Then you can use the MySQL concat function to combine two fields into one like this:

SELECT num, CONCAT(first_name, ' ', last_name) fullname
  FROM `<?php echo $TABLE_PREFIX ?>project`

This is example code, so you might need to change some of the variable names.

The field will use the num value for its value, and use the fullname meta field for its label.

Thanks!

Greg

That's great!

Is there also a way to add to this: where category=option1, so the list only shows contacts within the option1 category?

Hi Tim, 

You can do this by adding the where statement to the end of the current MySQL statement:

SELECT num, CONCAT(first_name, ' ', last_name) fullname
FROM `<?php echo $TABLE_PREFIX ?>project`
WHERE category = `option1`

Let me know if you have any questions.

Thanks

Greg

Hi Greg,

I keep getting errors with this;  I'm 100% positive that I have a list field called "type" in the "contacts" table.

SELECT num, CONCAT(first_name, ' ', last_name) fullname
FROM `<?php echo $TABLE_PREFIX ?>contacts`

works perfectly; however

SELECT num, CONCAT(first_name, ' ', last_name) fullname
FROM `<?php echo $TABLE_PREFIX ?>contacts`
WHERE type = `Person`

gives an error "Warning: Cannot modify header information - headers already sent by (output started at /home/toledoh1/public_html/cmsAdmin/lib/menus/header.php:13) in /home/toledoh1/public_html/cmsAdmin/lib/database_functions.php on line 554 There was an error creating the list field 'contact_person'. MySQL Error: Unknown column 'type = Person' in 'where clause'"