// creates a dropdown from a db table
function dyna_dropdown2($formObjName, $valueField, $nameField, $tableName, $selectedValue=NULL, $orderByValue=0)
{
$query="SELECT $valueField, $nameField FROM $tableName";
if($orderByValue)
$query.=" ORDER BY $valueField";
else
$query.=" ORDER BY $nameField";
$res=mysql_query($query);
$notSelected=1;
echo "<select name='$formObjName' id='$formObjName'>\n";
while( $row=mysql_fetch_assoc($res) )
{
echo "<option value='$row[$valueField]'";
if( $notSelected && $row[$valueField]==$selectedValue ) { echo ' selected'; $notSelected=0; }
echo ">$row[$nameField]</option>\n";
}
echo "</select>\n";
}
You want the form object to be called 'lovelyselect', your table is users, with id and name fields - use like:
dyna_dropdown2('lovelyselect', 'id', 'name', 'users');
You can optionally sort and have a pre-selected entry.
