Getting all enum set values from a field

[Rex__]

I want to have a bunch of checkboxes in an html form that will be used to insert data into an enum field in mysql.

I just want to know how i can get all the possible values, or options, from the database field instead of hardcoding it in the html. I know that php has a function that can get a field's name, but this is the closest function that I have found to getting what I need.

I suppose that I want to essentially enumerate an enum field 😕

[Rex__]

i found a possible solution...

$sql = "show columns from choices like 'chartype'"; 
$result = mysql_query($sql); 
$thisrow = mysql_fetch_array($result); 
$valuestring = $thisrow[1];
$enum = str_replace("enum(", "", $res[$i]['Type']); 
$enum = ereg_replace("\)$", "", $enum); 
$enum = str_replace("'", "", $enum); 
$enum = explode(",", $enum); 
echo "<SELECT name=$name>"; 
for($i = 0; $i < count($enum); $j++) 
	echo '<OPTION value="'.$enum[$j].'">'.$enum[$j]; 
echo '</SELECT>';