ENUM into a dropdown box

[QAteste]

Is it possible using php to get the items from a ENUM type into a html dropdown box? If so, can you point me in the right direction?

 

[sleipnir214]

There's likely a function for this, but here's one way...

Assume you have the following table "foo":

[tt]

+-------+--------------------------+------+-----+---------+----------------+
| Field | Type                     | Null | Key | Default | Extra          |
+-------+--------------------------+------+-----+---------+----------------+
| id    | tinyint unsigned         |      | PRI | NULL    | auto_increment |
| fu    | enum('No','Maybe','Yes') |      |     | No      |                |
+-------+--------------------------+------+-----+---------+----------------+

[/tt]

Then the following code:

[tt]

<?php

$dbh = mysql_connect ('localhost','test','test');

mysql_select_db ('test', $dbh);

$sql = &quot;DESCRIBE foo fu&quot;;

$result = mysql_query ($sql, $dbh);

$array = mysql_fetch_assoc ($result);

$enum_array = split (',',(preg_replace ('/enum\(|\)/', '', $array['Type'])));

?>

[/tt]

will initialize $enum_array to the values available in the enum field.
______________________________________________________________________
TANSTAAFL!