mySQL field and getting the ENUM list with PHP 3

[BlindPete]

I have a field in a mySQL table that is enumerated with several text strings.

Is there a way to read this enumeration list from PHP?
I want to populate a html option list. -Pete

 

[danielhozac]

You could issue [tt]DESCRIBE table_name[/tt] and read through the results and then fetching the enumeration and split it. I am sure there is a better way, but this is all I can think of right now. //Daniel

 

[sleipnir214]

If you want just the information of a single column, you can specify the column name in danielhozac's suggesttion:

describe tablename columnname

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BlindPete]

Thanks All, I will try it out, but I was hoping for something a little cleaner. -Pete

 

[sleipnir214]

How much cleaner do you need it?

Strip off the "enum(" from the beginning. Strip off the &quot" from the end. Split what remains at the commas into an array. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BlindPete]

yeah I wrote a function that does that. I was hoping for a function to just return the array directly, but you are right it only took minutes to write my own.

another one for the bag-o-tricks

Thanks All and a star for each of you! -Pete

 

[danielhozac]

I did not know that you could add the column name in there, so here's a star for you sleipnir214! //Daniel