[thelist] PHP and mySQL ENUM

[rudy limeback]

> If I have a table that contains a column that's defined as:
> column_name ENUM("value1", "value2", "value3", "value4"),
> is it possible to retrieve the ENUM values using PHP?

hi mike

not a mysql user myself, but a quick search of the mysql.com site turned
this up --

   "If you want to get all possible values for an ENUM column,
    you should use: SHOW COLUMNS FROM table_name LIKE
   enum_column_name and parse the ENUM definition in the
   second column. "
            http://mysql.com/documentation/manual.php?section=ENUM


rudy.limeback
r937.com
evolt.org