RE: [PHP] mysql_field_type() ...

2003-11-03 Thread Jay Blanchard
[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 if DESCRIBE db; //in the mysql table returns --

Re: [PHP] mysql_field_type() ...

2003-11-03 Thread John W. Holmes
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 if Even better is DESC table_name column_name; so you only