title: I want to display the message "no result found" when the query returns no result
body: <p>I am using the following code to search in the site..I wish to display the message "no result found" when the query returns no result.What changings should i do in the code</p>
  
  <p>The HTML is:</p>
  
  <pre><code>&lt;div class="form-container"&gt;
       &lt;form method="get" action="search.php"&gt;
        &lt;input type="text" name="search" placeholder="Search keywords..."/&gt;
        &lt;input type="submit" name="find" value=""&gt;
       &lt;/form&gt;
      &lt;/div&gt;
  </code></pre>
  
  <p>The PHP is:</p>
  
  <pre><code>&lt;?php
  if(isset($_GET['find'])){
   $search = @$_GET['search'];
   $query = "SELECT * FROM `me` WHERE `post_title` LIKE '%$search%'";
   $run = mysqli_query($con,$query);
  while($row=mysqli_fetch_assoc($run)):
      $post_id = $row['post_id'];
      $post_category = $row['post_category'];
      $post_author = $row['post_author'];
      $post_title = $row['post_title'];
      $post_content = substr($row['post_content'],0,700);
      $post_video = $row['post_video'];
      $post_misc = $row['post_misc'];
      $post_image = $row['post_image'];
      $post_date = $row['post_date'];
  ?&gt;
  
  
     &lt;a class="post_title" href="complete_post.php?complete1=&lt;?php echo $post_id; ?&gt;"&gt;
     &lt;?php echo $post_title; ?&gt;
     &lt;/a&gt;
     &lt;p style="color:#949494; font-family:calibri; text-align:justify; margin-left:8px; width:700px; font-size:15pt; float:left;"&gt;
     &lt;span style="float:left; font-size:9pt; font-family:arial; color:#959595;"&gt;
     By &lt;b&gt;&lt;?php echo $post_author; ?&gt;&lt;/b&gt; on &lt;b&gt;&lt;?php echo $post_date; ?&gt;&lt;/b&gt; in 
     &lt;b&gt;&lt;?php echo $post_category; ?&gt;&lt;/b&gt;
     &lt;/span&gt;
     &lt;/br&gt;
      &lt;?php echo $post_content; ?&gt;...
     &lt;/p&gt;
     &lt;a href="complete_post.php?complete=&lt;?php echo $post_id; ?&gt;" class="r-m"&gt;
     Read more..
     &lt;/a&gt;
  &lt;?php endwhile; } ?&gt; 
  </code></pre>