title: mysql vs mysqli not the same result?
body: <p>I have this old mysql query:</p>
  
  <pre><code>$sql = mysql_query("SELECT id FROM nf_users 
      WHERE points &gt; 
          (SELECT points FROM nf_users WHERE id = 1) 
      AND played &gt; 0");
  $row = mysql_fetch_array($sql);
  
  $rank = mysql_num_rows($sql)+1;
  </code></pre>
  
  <p>This gives the <code>$rank</code> a value of <code>2578</code>. Now if I try to do the same with mysqli like this:</p>
  
  <pre><code>$sql = mysqli_query($connect,"SELECT id FROM nf_users 
      WHERE points &gt; 
          (SELECT points FROM nf_users WHERE id = 1) 
      AND played &gt; 0");
  $row = mysqli_fetch_array($sql);
  
  $rank = mysqli_num_rows($sql)+1;
  </code></pre>
  
  <p>the <code>$rank</code> now only says <code>1</code>?</p>
  
  <p>What am I doing wrong?</p>
  
  <p>Please help and thanks in advance :-)</p>