if语句内没有显示空标记[重复]

Question

This question already has an answer here:

• How to check if MySQL results returned empty in PHP? 7 answers

Building a custom site for non-profit. Have a hang up on the search page.

Here is what I have...

It shows results but does not show anything for empty results. I can not figure this one out.

while($rowitem = mysqli_fetch_array($results)) 
    {

         If (empty($results))  
          {    

       echo 'NO RESULTS';


          }
         Else
         {
            echo  "<div>"; ..... 

There is a lot of code past this that works.

I appreciate any help that anyone can provide. I am sure it is something simple that I am screwing up.

</div>

Answer 1

while loop will not run in case of empty results so you need to check before while:

if(empty($results)){
    echo 'NO RESULTS';
else{
    while($rowitem = mysqli_fetch_array($results)) {
        /* your code here */
    }
}