Getting values from 'enum' field

[knickerlas]

Hi
is there a way to retrive the enum values from a field?

Like this:

enum 'red','green','blue' (you ´get the idea!)

cool_func($field);

result = an array containing red green and blue.

Hope you understand

Nick

[Anon]

Nick

I dont know of anything built in but you could try...

$sqla = "show columns from YOURTABLE";
$result = mysql_query($sqla);
while ($myrow = mysql_fetch_row($result)){
if (substr($myrow[1],0,4) == "enum"){
$enums = substr($myrow[1],5,-1);
echo $enums;
}
}

It's not pretty but it does work.

Hope this helps

Paul

[knickerlas]

Thanks paul, I was sitting here fiddling with ereg() on the string when I got your post, so it couldn't have come at a better time!
All I have to do now is extract the values minus the ' and , chars but it's about time I learnt a little more about regular expressins anyway!

Thanks again

Nick