MySQL enum and PHP

[guyfromfl]

Is there a way to read a enum'd field's values into an array in php so i can populate a dropdown box with the possible choices? 

 

This way I don't have to change anything if i alter the table.

 

thanks

 

[Mchl]

You could parse results of

 

EXPLAIN `table` `enumField`

[corbin]

What kind of values are you using in an enum?  Like what will the column hold?  Perhaps you shouldn't use an enum.

[impressthenet]

Is there a way to read a enum'd field's values into an array in php so i can populate a dropdown box with the possible choices? 

 

This way I don't have to change anything if i alter the table.

 

thanks

 

You mean something like this?

$enumArray = explode(",",$row["enumtype"]);