Collecting info about columns in a table
| From: | Afan Pasalic | Date: | Sun, 29 Jan 2006 16:17:47 +0000 |
| Subject: | Collecting info about columns in a table | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-229421@lists.php.net to get a copy of this message | ||
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