将mysqli_num_rows等同于0但它不起作用

Question

I have a mysql query that I get data from mysql table. How can I properly check if there is result returned? My mysql table have 5 rows with data.

I have tried to equate mysqli_num_rows to 0 but it does not work. It always return fail. I need it to return success.

I can't figure this out, how can I fix this?

my code:

$result=mysqli_num_rows($query)

if($result==0)
{
    echo "Success";
}else
{
    echo "fail";
}

Answer 1

Your statement only evaluates to true if mysqli_num_rows is equal to 1:

if($test = mysqli_num_rows($result) == 0){

You should check if it is equal more than 0, so that it will evaluate true when it returns more than 1 row:

$result = mysqli_num_rows($query)

if ($result == 0) {
    echo "Success";
} else {
    echo "fail";
}

---

Usage of mysqli_num_rows():

Returns the number of rows in the result set.