Re: [PHP-DB] retrieve enum values

2005-04-14 Thread Aman Patel
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

RE: [PHP-DB] retrieve enum values

2005-04-14 Thread Patel, Aman
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, -

RE: [PHP-DB] retrieve enum values

2005-04-14 Thread Jason
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... $name"; } ?> Hope that speaks to your question. Jason -Original Message- From: mel list_php [mai