mySQL ENUM fields with PHP

[Anon]

Hi,

Lets say I have an enum field:
account_type ENUM('Visa/MC','American Express','Discover','JCB')

and I would like to be able to extract the Visa/MC, American Express, etc.. and put them into an array so I can produce the output:

<select name=account_type>
<option value=Visa/MC>Visa/MC</option>
<option value=American Express>American Express</option>
<option value=>etc...</option>
</select>

Any help would be appreciated,

Thanks
Steve

[amcgrath]

The only way I know of (and there could be a better way) is to "show columns from $table" and parse through the results... it's a lil clunky, so I hope to see a posting for a better way.

[Anon]

That seems to be the response I am getting... So last night I sat down and wrote a function to do just that. Here is a copy of it for anyone else that is interested.

function enum_vals($table,$field)
{
global $db;
$sql="DESCRIBE ".$table;
$result = mysql_query($sql)
or exit();
while ($myrow = mysql_fetch_row($result))
{
if ($myrow[0]==$field)
{
if (substr($myrow[1],0,4) == "enum")
{
$enums = substr($myrow[1],5,-1);
//remove ''
$enums = str_replace("'","",$enums);
//remove ()
$enums = str_replace("(","",$enums);
$enums = str_replace(")","",$enums);
//turn into array
$enumarray = explode(",",$enums);
return($enumarray);
}
}
}
}