Enumerated fields

[Anon]

How do I get the values from an (mysql) ENUM field type from the database and then show them in a drop down box??

[Anon]

Not really familiar with ENUM fields but it should work the same way as any other

$result = mysql_query("SELECT DISTINCT enumfield from tablename", $db);
print '<select name=somename>';
while ($myrow = mysql_fetch_array($result)) {
printf('<option value="%s">%s', $myrow["enumfield"], $myrow["enumfield"]);
}
print '</select>';

[Anon]

to get the row (which also contains the enum-values) use the following query:

SHOW COLUMNS FROM yourtable LIKE 'enumfield'