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.
You have a couple of choices if I remember correctly.. For a table of name
'TBL':
describe TBL;
explain TBL;
show columns from TBL;
-Micah
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
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
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;