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" <bastian.vogt@komtel.net> To: <php-db@lists.php.net> Sent: Monday, December 02, 2002 11:41 PM Subject: 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 > > > -- > 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