help with mysql_fetch_row

Anon

Hey everyone i'm working on a script where it pulls the most recent entry to a journal and then post the users name where i would likeit to be.

i test all my scripts on my own box here at home, but when i try it on my sites server the script wont work.

here is the code that i have its quite simple for now, just for testing:

<head>
<title></title>
</head>
</body>
<?php

$connection = mysql_connect("localhost" , "user" , "password");
$db = mysql_select_db("db", $connection);
$query = "SELECT * FROM entry ORDER BY entry_created_by DESC LIMIT 3";
$result = mysql_query($query);

echo ("<table border = '0' width = '90%'>

Anon

#while ($rows = mysql_fetch_row($result)) {

echo ("<tr><td>$rows[2]</td></tr>");

#echo "</table>";

#?>
#</body>
#
#--------------------------------------------------------------

here is the error that i get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/violentl/public_html/test/vf_usertable.php on line 16

i just cant figure it out. any help would be so appreciated.

thanks again