mysql error

[figa11]

I never have written php or mysql, I usually just buy the sites and upload them. Can someone please tell me why I'm getting this error?

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/figa11/public_html/investments/index.php on line 49

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/figa11/public_html/investments/dailyroutine.php on line 30

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/figa11/public_html/investments/dailyroutine.php on line 70

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/figa11/public_html/investments/dailyroutine.php on line 152

[eran]

You have failing queries. mysql_query() returns a resource or a boolean false - the error is telling you that you trying to pass a failed query result into mysql_num_rows() which expects a mysql result resource.

 

You need to perform a check before passing a mysql_query(), something of the form

 

$result = mysql_query(...);
if($result) {
    //use result in mysql_num_rows or any other relevant function
} else {
    // debug / log error using mysql_error()
}

[figa11]

You have failing queries. mysql_query() returns a resource or a boolean false - the error is telling you that you trying to pass a failed query result into mysql_num_rows() which expects a mysql result resource.

 

You need to perform a check before passing a mysql_query(), something of the form

 

$result = mysql_query(...);
if($result) {
    //use result in mysql_num_rows or any other relevant function
} else {
    // debug / log error using mysql_error()
}

 

Am i supposed to add that code somewhere inside the code on my site

Thanks very much for your response

[Pikachu2000]

Your query is failing. Post your code so we don't have to try to guess what the problem is.