I think Afan means they are values in an enum field. But I may be mistaken... :)
Gerry
On 1/29/06, tedd <[EMAIL PROTECTED]> wrote:
> >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
>
> -afan:
>
> $type = mysql_field_type($result, 'live');
> $name = mysql_field_name($result, 'hidden');
> $len = mysql_field_len($result, 'pending');
>
> Provided that 'live', 'hidden', 'pending' are fields in your table.
--
Gerry
http://portal.danen.org/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
