RE: [PHP-DB] getting database tables
| From: | Rick Emery | Date: | Mon, 12 Nov 2001 17:46:31 +0000 |
| Subject: | RE: [PHP-DB] getting database tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14257@lists.php.net to get a copy of this message | ||
In PHP:
$query = "SHOW TABLES";
$result = mysql_query($query) or DIE("Error: ".mysql_error());
while( $row = mysql_fetch_array($result) )
{
do some stuff with $row
}
-----Original Message-----
From: mike luce [mailto:mikeluce@hotmail.com]
Sent: Monday, November 12, 2001 3:10 AM
To: php-db@lists.php.net
Subject: [PHP-DB] getting database tables
Can someone give me some help on obtaining a list of tables in a database?
Ive had no luck so far because i keep encountering an error which just times
out the page.
Any help would be welcome.
thanks.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net