title: While loop is repeating only the first row multiple times
body: <p>I am trying to output all the rows of  the result of a database query but my while loop keeps repeating only the first row multiple times. It repeats only the first row the total number of times of expected outcome. Please I need help.</p>
  
  <pre><code>$sql = "SELECT * FROM review WHERE lid = '".$_GET['id']."'";
  $result = $conn -&gt; query($sql);
  $row = $result -&gt; fetch_assoc();
  
  if (mysqli_num_rows($result) == 0){
      echo "&lt;div class='no-comment'&gt;No Comments found!&lt;/div&gt;
      &lt;button class='btn btn-default btn-lg center-block' data-toggle='modal' data-target='#Review'&gt;Review Lecturer Now!&lt;/button&gt;
      ";
  }else{
      while($result -&gt; fetch_assoc()){
          echo"
              &lt;div class='comment'&gt;
                  &lt;div class='reviewer-name'&gt;".$row['rid']."&lt;span class='review-date'&gt;".$row['reviewDate']."&lt;/span&gt;&lt;hr&gt;
                  &lt;p&gt;".$row['review']."&lt;/p&gt;&lt;/div&gt;
              &lt;/div&gt;
              ";
      }
  }
  </code></pre>