Posted by Duderino82 on 03/18/06 00:05

$sql = "SHOW COLUMNS FROM table LIKE 'subject' ";
$qry = mysql_query($sql) or die("Query not valid: " . mysql_error());
$res = mysql_fetch_object($qry);
// This returns a row with a field 'Type' containing 'enum(...)'

$res->Type = str_replace('enum(\'', '', $res->Type);
$res->Type = str_replace('\')', '', $res->Type);
//now the string is something like this: one','two','three

$temp = explode('\',\'',$res->Type);
//temp is an array with as much elements as the enum

while ($temp)
print array_pop($temp);



This way is much more easier using the elements since they are elements
of an array. Cleaver isn't it?

• Next in forum: mysql_connect error
• Prev in forum: Re: Retrieve fields with similar values from 2 tables?
• Thread view: Populating form item from SQL enum set Rev#2

[Reply to this message]