如何获取mysqli_num_row值

Question

Im learning and doing some excercises from a book, and I have an arror after a query.

I want to know the value of mysqli_num_row to further understand my error but I do not get a value.

I already check and if I put echo 'r'; I get an r in the screen so I know that line is getting executed but I can not get anything for the value of mysqli_num_row.

What should I write in the final line to get this value on the screen?

$q = "SELECT user_id, first_name FROM users WHERE email='$e' AND pass=SHA1('$p')";
$r = @mysqli_query($dbc, $q); // Run the query.
echo mysqli_num_row($r);

Right now I am just getting a blank screen.

Thanks.

Answer 1

you are using wrong function it is actually mysqli_num_rows(); you are missing s in the end of row

echo mysqli_num_rows($r);

http://www.w3schools.com/php/func_mysqli_num_rows.asp