what this error message means ?

[Anon]

Hello,
I got the following code:
$query = "select * from databaseTable";
$result = mysql_db_query("database", $query);
$num_rows = mysql_num_rows($result);
and i got the folloing error message

0 is not a MySQL result index in /home/hoang/WWW/afb_dev/testLinks.php on line 2

can someone explain what does this means ??

[Anon]

Well first of all, use this:

$connection = mysql_connect("localhost", "uname", "pass");
mysql_select_db("database", $connection);
$query = "SELECT * FROM databaseTable";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);

that should fix the problem