Collecting info about columns in a table

["Afan Pasalic" <afan@xxxxxxxx>]

Hi to all,
I need to collect info about columns from a selected table.
I use this:

$result = mysql_query("SELECT * FROM ". $TableName);
$fields = mysql_num_fields($result);
for ($i=0; $i < $fields; $i++)
{
	$type  = mysql_field_type($result, $i);
	$name  = mysql_field_name($result, $i);
	$len  = mysql_field_len($result, $i);
	$flags = mysql_field_flags($result, $i);

   echo $type . " | " . $name . " | " . $len . " | " . $flags ."\n";
}

If I have columns type ENUM('live', 'hidden', 'pending'), $flags will show  
ONLY 'enum'.
How can I get all ENUM values?

Thanks for any help or direction.

-afan

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php