"show tables" sql command

[Anon]

Hi,

I wrote a simple php file just to show the tables in a MySql database.

<?
mysql_connect(localhost,db_name,pwd)
or die("Unable to connect to SQL server");
mysql_select_db(db_name);

$query = "show tables";
$result = mysql_query($query);
echo $result;
?>

Somehow it only says "Resource id #2" when I execute the script through my browser.

I have no idea what "Resource id #2" means, but I cant find problems with my script...Any idea is greatly appreciated, thankyou in advance.

[preetha]

hi,
Hope this might help u.

/ mysql_connect takes parameters

(server,user,password) /
mysql_connect(localhost,user,pwd)
or die("Unable to connect to SQL server");

mysql_select_db(db_name);

$query = "show tables";
$result = mysql_query($query);

//The result is an associative array
while ($row=mysql_fetch_array($result))
{
echo $row[0];
echo "<br>";
}