[Resolved] SELECT problem

[baffled_in_UK]

Hi,

Can someone please tell me why I get this error :

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #5' at line 1"
with this code:

$result = mysql_query("SELECT * FROM league_entries ORDER BY pts, tens DESC",$db);

My MySQL Client API Version is 4.0.12

Thanks

[stolzyboy]

show a little bit more code above and below the error line

[baffled_in_UK]

above:

$db = @mysql_connect("localhost","user","pwd") or header("Location: error.php");
mysql_select_db("dbase",$db) or header("Location: error.php");

below:

while ($myrow = mysql_fetch_array($result1))  {  

that enough ?

[stolzyboy]

change this line

$result = mysql_query("SELECT * FROM league_entries ORDER BY pts, tens DESC",$db);

to this

$result = mysql_query("SELECT * FROM league_entries ORDER BY pts, tens DESC",$db) or die(mysql_error());

to see a better error, and also on your

while ($myrow = mysql_fetch_array($result1)) {

line, you are using $result1, when it should be $result