I have a column type enum in mysql.
At the moment the possible values are 1,2 and 3.

I make a form for my user to modify that value, something like:
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>

I may need to add a value 4 to the enum, and in that case I would like to avoid modifying the code.

I would like to know it it is possible to have something like:
select possible_enum_values from table ...
and then having a loop through these values.
I can't select distinct values in that column because one value may not exist yet and I don't want to have fake records.

I found that in the mysql doc and was wondering if there is an already implemented php function intsead of having to parse:
" If you want to determine all possible values for an ENUM column, use SHOW COLUMNS FROM tbl_name LIKE enum_col and parse the ENUM definition in the second column of the output."

Any idea?


It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to