[PHP-DB] getting database tables

2001-11-12 Thread mike luce 

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] getting database tables

2001-11-12 Thread Rick Emery 

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:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 3:10 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] getting database tables

2001-11-12 Thread Beau Lebens 

or even

mysql_list_tables()

:)

/beau

// -Original Message-
// From: Rick Emery [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 13 November 2001 1:47 AM
// To: 'mike luce'; [EMAIL PROTECTED]
// Subject: RE: [PHP-DB] getting database tables
// 
// 
// 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:[EMAIL PROTECTED]]
// Sent: Monday, November 12, 2001 3:10 AM
// To: [EMAIL PROTECTED]
// 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]