Now that I see code, I would say just run a 'SELECT * FROM table LIMIT 1' on
your table, and run it through your code. That should give you what you want.
-Micah
On Wed September 10 2003 12:55 pm, Peter Beckman wrote:
> On Wed, 10 Sep 2003, Micah Stevens wrote:
> > describe TBL;
> > explain TBL;
> > show columns from TBL;
>
> Yes, they do give the correct information.
>
> However, my question was is there a nice simple SQL command that will
> return exactly what mysql_list_fields (now depreciated) so that the
> $result can be used with the mysql_field_* functions.
>
> All of the above commands give the exact same data in the same format, all
> of which are incompatible with the mysql_field_* functions.
>
> $fld_results = mysql_query("show fields from ".$db.".".$tbl) or
> die(mysql_error().'PMA_mysql_list_fields(' . $db . ', ' . $tbl . ')');
> $fld_results_cnt = ($fld_results) ? mysql_num_fields($fld_results) : 0; for
> ($j = 0; $j < $fld_results_cnt; $j++) {
> echo mysql_field_name($fld_results, $j) . "<br/>";
> }
>
> Returns:
>
> Field
> Type
> Null
> Key
> Default
> Extra
>
> instead of what I was expecting.
>
> > On Wed September 10 2003 12:08 pm, Peter Beckman wrote:
> > > So PHP is saying mysql_list_tables is depreciated. I replaced it with
> > > mysql_query("SHOW TABLES FROM DB") and everything is fine.
> > >
> > > Then mysql_list_fields didn't work right. So I submitted a bug
> > > (http://bugs.php.net/bug.php?id=25460) about it, and they said IT TOO
> > > was depreciated, which is fine. But I haven't figured out how to
> > > replace mysql_list_fields with a nice simple SQL command, since a bunch
> > > of code relies on mysql_list_fields to return a nice $result (ie
> > > Resource #37) to use with mysql_field_flags, mysql_field_name, etc.
> > >
> > > Anyone got any ideas on how to do that without replacing
> > > mysql_field_flags et al? Or do I have to rewrite the code entirely to
> > > use "SHOW FIELDS FROM DB.TABLE" and rewrite my own _field_ functions?
>
> ---------------------------------------------------------------------------
> Peter Beckman Internet Guy
> beckman@purplecow.com http://www.purplecow.com/
> ---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
