Re: mysql_field_type() ...
| From: | John W. Holmes | Date: | Mon, 03 Nov 2003 23:44:32 +0000 |
| Subject: | Re: mysql_field_type() ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168427@lists.php.net to get a copy of this message | ||
Jay Blanchard wrote:
[snip] ...will say if a field is of type "ENUM", but not its possible values (including default). Does anyone know how I can fetch possible values of a field type of ENUM? [/snip] You would have to use DESCRIBE. So ifEven better is DESC table_name column_name; so you only have to parse one row (if you're only after one row). :) -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com