RE: [PHP] retrieving ENUM description from MySQL

s... Jeff > -Original Message----- > From: Alan Lord [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 19, 2003 12:12 PM > To: [EMAIL PROTECTED] > Subject: [PHP] retrieving ENUM description from MySQL > > > Hi all, > > This is a bit wierd so don't flam

Re: [PHP] retrieving ENUM description from MySQL

Alan Lord wrote: Imagine a database table, field defined as ENUM with a list of allowed types such as "Mr", "Mrs", "Miss", "Dr", "Prof", etc - you get the idea. I've read the MySQL manual and by using SHOW COLUMNS FROM "table_name" LIKE "enum_column_name"; I can get a result. But the string of

[PHP] retrieving ENUM description from MySQL

Hi all, This is a bit wierd so don't flame please. Imagine a database table, field defined as ENUM with a list of allowed types such as "Mr", "Mrs", "Miss", "Dr", "Prof", etc - you get the idea. I've read the MySQL manual and by using SHOW COLUMNS FROM "table_name" LIKE "enum_column_name"; I c