Why I do not get first row if am using mysqli_fetch_assoc on first and mysqli_fetch_array second time?
<p>I am populating database column names for sorting my query in a sidebar list using <code>mysqli_fetch_assoc()</code> and that page is included on result page where I am using <code>mysqli_fetch_array()</code> to populate the table rows, now what the funny thing was on the result page I was getting only 3 rows where my database was having 4 rows, 1 row less, I was debugging entire code and I came accross that I am using <code>mysqli_fetch_assoc()</code> and <code>mysqli_fetch_array()</code> for same query, so if I removed <code>mysqli_fetch_assoc()</code> it used to return me 4 rows, but why is this so? I didn't got a bit</p>

<p>I thought I'll populate a comma separated names of table in my database and will explode later but after some internet research I came across this <code>mysqli_data_seek($fetch_results, 0);</code> and it solved my issue, but why I was getting 1 row less and after using <code>mysqli_data_seek($fetch_results, 0);</code> it returned me all rows that is 4 instead of 3? Can anyone explain me?</p>

<blockquote>
  <p>P.S Am using excessive eval as I am developing customized systems, but
  this is not the issue here, it's secure :)</p>
</blockquote>
