[PHP-DB] mysql - enum

Hi, is it possible to get all possible values of an enum-field from a mysql-table in php? The values might be changed in the database. Now I've got an select-field in my php-app where the user can select each value of the enum-field for a new record befor saving... Thanks for any reply, Bastian

Re: [PHP-DB] mysql - enum

DESCRIBE tbl_name col_name Ignatius - Original Message - From: Bastian Vogt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 02, 2002 1:41 PM Subject: [PHP-DB] mysql - enum Hi, is it possible to get all possible values

Re: [PHP-DB] mysql - enum

This is what I use: SHOW COLUMNS FROM table LIKE field I use the query result for a select field in HTML table. Ruth - Original Message - From: Bastian Vogt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 02, 2002 11:41 PM Subject: [PHP-DB] mysql - enum Hi

[PHP-DB] MySQL enum displaying values in Select

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.