If I understand you correctly.. you want to loop through a select statement
and put the enum values in the value of the select box? 
If that's the case then here is how you would do that...
$query = "select * from foo where bar";
$result = mysql_query($query);
While($row = mysql_fetch_row($result)) {
$enumVal = $row[0];
$name    = $row[1];
Print "<option value=\"$enumVal\">$name</option>";
Hope that speaks to your question.


-----Original Message-----
From: mel list_php [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 14, 2005 5:54 AM
To: php-db@lists.php.net
Subject: [PHP-DB] retrieve enum values


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! 

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

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

Reply via email to