Hello, I have a problem I can't seem to overcome. Maybe it's just something simple but for some reason I am unable to read in values from a mysql db column (enum) and display the results in an option box.
I can display the values to the screen but I can't seem to get them into the option box. This is the snippet of code I've been struggling with... what am I doing wrong? All I get in the option box is one value called 'Array' which isn't even a value from my enum column. Please let me know if you need more info. Thanks for the help. Rob. (db connections strings here.....) $sql = "SHOW COLUMNS FROM $table_name LIKE 'categories'"; $result = @mysql_query($sql); $query_data = mysql_fetch_array($result); if (eregi("('.*')", $query_data["Type"], $match)) { $enum_str = ereg_replace("'", "", $match[1]); $enum_options = explode(',', $enum_str); } array_push($enum_options, $query_data); echo "ENUM options with the default value:<br>"; foreach($enum_options as $value) echo "$value<br>"; ?> <SELECT NAME=$categories size=5 multiple> <SELECT NAME=member_groups[] size=5 multiple> <option><? echo "$value"; ?></option> </SELECT> <? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php