[RESOLVED] Displaying Tables

[obrienkev]

Hi all,

How do I display al lthe table names in a database on a php page?

I've tried this...

// connect to db
include('db_connect.php');

// perform query
$query = "SHOW tables";

$result = mysql_query($query) or die(mysql_error());

echo $result;

But only get Resource id#3

[thorpe]

$query = "SHOW TABLES"; 
$result = mysql_query($query) or die(mysql_error()); 
while ($row = mysql_fetch_row($result)) {
    echo $row[0];
}