On Dec 6, 2007 1:38 PM, Afan Pasalic <afan@xxxxxxxx> wrote: > hi, > I use the code from > http://www.php.net/manual/en/function.mysql-fetch-field > (example #1) > I'm getting everything I need but can't recognize if the column is > ENUM() type? > > e.g. column "status" is ENUM('0','1') or ENUM('live','hidden','archive') > or something like that. I want to recognize this column and then create > a form with radio buttons > o 0 o 1 or > o live o hidden o archive > > is it possible? > > thanks. > > -afan The only way I've seen to do this is to first execute the query DESCRIBE `my_table` and then examine the value of the `Type` column that is returned for the row that represents the column you are examining in your regular query. You just have to strip the 'ENUM(' and ')' from the beginning and end and then split the remaining string. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
