Re: Collecting info about columns in a table

I think Afan means they are values in an enum field. But I may be mistaken.... :) Gerry On 1/29/06, tedd <tedd@sperling.com> 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/