Re: getting the options in a mysql enum
| From: | Chris Adams | Date: | Wed, 26 Jul 2000 01:39:28 +0000 |
| Subject: | Re: getting the options in a mysql enum | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1494@lists.php.net to get a copy of this message | ||
> Is there any way I can get a list of the possible values in a mysql ENUM
> column?
$description = mysql_query("DESCRIBE [Database.]Table Column");
echo mysql_result($description, 0);
Note that this is the raw description, so you'll need to do a little
parsing.