How can I proceed with the else statement after reaching the last record of the table?

1. i have a flag table

2. What I want to do is: after the table query reaches the last record, it then performs the else statement

   while($row = $result->fetch_array()){
   if (++$counter == $numResults) {
       $sql1 = "UPDATE QueueP1 SET STATUS = '1' WHERE STATUS ='0' LIMIT 1";
       $result1 = $conn->query($sql1);
       echo "Now processing No ".$row['now']."<Br>";       
       }
    else{
       echo "<p class='lead'><em>No more transactions left.</em></p>";
   

   } }