title: Check if no result found in mysql db
body: <p>I wrote a php search for a table in mysqli and it works fine but i want to show the correct message to user if no result were found.</p>
  
  <p>here is my current code:</p>
  
  <pre><code>$search_string=$_GET["design"];
  
  $connect= mysqli_connect("mysql.myhost.com","abc","123456","mydb_db");
  $query="select * from product where product_design like '%$search_string%'";
  $rows= @mysqli_query($connect,$query) or die("Error: ".mysqli_error($connect));
  if ($rows!=null)//I put this if to check if there is any result or not but its not working
  {
  
  while(($record=mysqli_fetch_row($rows))!=null)
  {
      .
              .//i have working code for showing the result here
              .
  }   
  mysqli_close($connect);
  }
  else{
  echo"no result found";
  }
  </code></pre>
  
  <p>could you please help me what is wrong , even when i search for something which is not exist in the db still the program not displaying "no result found"</p>
  
  <p>Thank you</p>