Thanks to everyone who helped me, Cole
pete M wrote:
this is where smarty templating is so cool using PEAR db
php code
$sql = 'select id, name from names order by name asc'; $smarty->assign('names',$db->getAssoc($sql));
template
<select name="name"> {html_options options=$names} </select>
Cole Ashcraft wrote:
How would you create a drop down menu from a database query? I have figured how to do it with one field, but how could it be done with a system where the value is different than the displayed value (ie. numerical code as the value, name displayed)?
Thanks, Cole
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php