Help with mysqli_num_rows

gtibbetts · Feb 18, 2020

It seems to me I have this coded right. For some reason I am getting an error. When I use mysqli_num_rows($result) I get the following error. I even tried mysqli_num_rows(mysqli_result, $result) and it gives me an error saying there should only be one parameter in the function call.

Here's my code.

if (mysqli_num_rows($result) > 0) {

It gives me the following error.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/a47dode5oten/public_html/scripts/automation/check-joes-datacenter-stock.php on line 30

NogDog · Feb 19, 2020

Usually means the query failed for some reason (SQL syntax error, etc.), so the call to mysqli_query() returned Boolean false instead of a mysqli result object. Also, it looks like mysqli_query() would return Boolean true on certain types of queries: https://www.php.net/manual/en/mysqli.query.php#refsect1-mysqli.query-returnvalues

Weedpacket · Feb 19, 2020

gtibbetts it gives me an error saying there should only be one parameter in the function call.

That is not what the error message is saying. It is saying that the one argument you did give it had the wrong type.