title: MySQL SELECT statement only returning one row
body: <p>I know for certain that there are two rows of data in my table that meet the condition of the where clause, yet my coding is only outputting (echoing) one row. What am I doing wrong?   </p>
  
  <pre><code>&lt;?php
  
  
  $connect= mysqli_connect("localhost", "root", "", "friends_list")
  or die('error connecting with the database');
  
  $query= "SELECT * FROM people WHERE age=19";
  
  $result= mysqli_query($connect, $query)
  or die('error querying the database');
  
  $row= mysqli_fetch_array($result);
  
  while ($row = mysqli_fetch_array($result))
  {
  echo $row['first_name'] . " " . $row['last_name'] . " is " . $row['age'] . "&lt;br/&gt;"                             
  }
  mysqli_close($connect);
  
  ?&gt;
  </code></pre>