Error: Warning: mysql_num_rows(): ...

[acctman]

i'm receiving this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Line 59

 

$result = mysql_query($sql,$db);

if(mysql_num_rows($result)==1) // This is Line 59

[rhodesa]

Your query is failing. Use this for more debug info:

 

$result = mysql_query($sql,$db)
  or die("Query error: ".mysql_error());

if(mysql_num_rows($result)==1) // This is Line 59

 

Edit: If you still can't figure it out, provide the query.

[obsidian]

It most likely means you have an error in your SQL syntax or something else wrong with the query. Do this to trouble shoot:

<?php
$res = mysql_query($sql, $db) or die(mysql_error());
if (mysql_num_rows($res) == 1)
{

}
?>

[rhodesa]

It most likely means you have an error in your SQL syntax or something else wrong with the query. Do this to trouble shoot:

<?php
$res = mysql_query($sql, $db) or die(mysql_error());
if (mysql_num_rows($res) == 1)
{

}
?>

 

...51 seconds too late ;-)

[acctman]

i changed mysql_query to sql_query and everything worked

[rhodesa]

well...sql_query is not a PHP function....so you must have some custom functions defined