On Wed, 10 Sep 2003, Peter Beckman wrote:

> 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.

 Figured it out:

 replace: $result = mysql_list_fields($db, $table [, $link])
    with: $result = mysql_query("SELECT * FROM ".$db.".".$table." LIMIT 1" [, $link])

 Works with mysql_field_* functions (at least it seems to) correctly.

 Since mysql_list_fields is now depreciated, you might want to check your
 code out soon/now to make sure you don't get screwed when the PHP team
 takes mysql_list_fields out of PHP entirely.

 Don't you love it when you figure out your own question?

Peter Beckman                                                  Internet Guy
[EMAIL PROTECTED]                             http://www.purplecow.com/

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

Reply via email to