title: Mysqli while dont show all rows
body: <p>I got an problem, PHP while dont show all rows from database if I do it on DESC it shows all but not last one if I use ASC it shows all but not first one. I tryed many solutions but none worked yet.</p>
  
  <p>Please help me at this code:</p>
  
  <pre><code>$sql1 = " SELECT * FROM news ORDER BY id DESC";
  
  if ($result1 = $mysqli-&gt;query($sql1)) {
      $news = $result1-&gt;fetch_array();
  } 
  while($row = mysqli_fetch_array($result1)) {
  echo "&lt;p&gt;&lt;b&gt; {$row['name']} &lt;/b&gt;&lt;br /&gt;";
  echo "{$row['text']} &lt;br /&gt;";
  echo "&lt;font size='2'&gt;{$row['date']}&lt;/font&gt;&lt;/p&gt;";
      }
  </code></pre>