Php Programming Code Examples
Php > Database Related Code Examples
ENUM Fields
ENUM Fields
<?
function DrawComboFromEnum($table,$field)
{
//connect to DB;
$query=mysql_query("SHOW COLUMNS FROM ".$table." LIKE '".$field."'") or die (mysql_error());
if(mysql_num_rows($query)>0)
{
$row=mysql_fetch_row($query);
$options=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$row[1]));
}
for ($i=0;$i<count($options);$i++)
{
$items.="<option value=\"".$options[$i]."\">".ucfirst($options[$i])."</option>\n";
}
$text="\n\n<select>\n";
$text.=$items;
$text.="</select>\n\n";
return "items<hr>".$text;
}
?>
