如何在while循环之前检查php mysqli_fetch_array是否为空

Question

I wanted to make sure there are results before running the while loop but all the methods I am trying seem to remove the first result.

$nearbyResult = mysqli_query($con,$sqlNearby);

if(mysqli_fetch_array($nearbyResult) == 0) {
    echo '<p>No results found, <a href="/add.php">Add your property here</a>.</p>';
} else {
    while($rowNearby = mysqli_fetch_array($nearbyResult)) {
    }
}

Answer 1

This line will take the first row of your result set and chuck it in the bin:

if(mysqli_fetch_array($nearbyResult) == 0) {

Change to:

if( ! mysqli_num_rows($nearbyResult) ) {

And check your freakin function returns:

if( ! $nearbyResult = mysqli_query($con,$sqlNearby) ) {
    echo "Mysql error: " . mysqli_error($con);
}