Re: retrieve enum values

A little correction in the code: ---------------- define(G_ENUM_COLUMN,4); // set this to 4 if you are using "SET" column type, and 4 for "ENUM" column type. /* Return the SET or ENUM set of values. $p_start can be 3 for SET... or 4 for ENUM... */ function get_set_column_values ( $p_table, $p_colname ) { $query = "SHOW COLUMNS FROM {$p_table} LIKE '{$p_colname}';"; $result = mysql_query($query); $arr = mysql_fetch_array( $result ); $value = substr( $arr[1], G_ENUM_COLUMN ); eval("\$the_array = array $value;"); // let eval do all the parsing return $the_array; } ---------------- Patel, Aman wrote:

Melanie, Here's a function that will parse the SHOW COLUMNS query output and will return an array of ENUM values, after you have the array it should be easy to generate the html code you need. The first two parameters are self explanatory (the table name and the column name). Hope this helps, -------------------- define(G_ENUM_COLUMN,4); // set this to 4 if you are using "SET" column type, and 4 for "ENUM" column type. /* Return the SET or ENUM set of values. $p_start can be 3 for SET... or 4 for ENUM... */ function get_set_column_values ( $p_table, $p_colname ) { $result = mysql_query($query); $arr = mysql_fetch_array( doQuery( "SHOW COLUMNS FROM $p_table LIKE '$p_colname';" ) ); $value = substr( $arr[1], G_ENUM_COLUMN ); eval( "\$the_array = array $value;" ); // let eval do all the parsing work. return $the_array; } -------------------- - Aman Patel, Sys Admin / Database / Web Developer, International Outreach x4076

-----Original Message----- From: mel list_php [mailto:list_php@hotmail.co.uk] Sent: Thursday, April 14, 2005 7:54 AM To: php-db@lists.php.net Subject: [PHP-DB] retrieve enum values Hi! 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: <select> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> </select> 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? Melanie _________________________________________________________________ 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