title: MySQL query not returning all rows
body: <p>I am developing a leaderboard. Using the query below I get most, but <em>not</em> all player statistics returned. <strong>It is missing the first row of the results.</strong>.</p>
  
  <pre><code>$query = mysql_query("SELECT * FROM statistics WHERE id = " . $playlist . " ORDER BY " . $statistic . " DESC LIMIT 100")
  </code></pre>
  
  <p><strong>RESOLVED</strong>: I had <strong>$user = mysql_fetch_array($query)</strong> above the line <strong>while($user = mysql_fetch_array($query)</strong> resulting in the pointer being advanced by 1 row.</p>