Less records are displayed than already exists In The DB!?

[saidbakr]

I have a MS Access data base file, has ODBC name as "msacc". This file includes table named as
"data_" this table contains about 564 record. I have wrote the following code to extract records
from this table in form of multible tables where every table contains 25 records. Till this point
every thing go well, but, the code displays only 475 records only, this will be displayed
in the attached photo,.
So why this problem is evolved? and what's its solution?

<?


   $con = odbc_connect("msacc","","");
   $sql = "SELECT * FROM data_";
   $doit = odbc_exec($con, $sql);
   $cut = 1;
   ?>

   <br><br>
   <table border=1 width="70%">
   <tr>
   <td>SER</td>
   <td>Name</td>
   </tr>
   <?
   while (odbc_fetch_row($doit))
   {

   print("<tr><td>".$cut."</td><td>  ".odbc_result($doit,"name")."</td></tr>");

  if ($cut%25 == 0)
  {
      print("</table><br><br><table border=1 width='70%'><tr><td>SER</td><td>Name</td>");
  }
   $cut = $cut + 1;
   }
 ?>

😕 😕

[tomhath]

You should have a </table? tag after the loop.

Other than that, I'd try to find what rows are missing. At the beginning, end, between cuts?

[saidbakr]

Sorry, and thank you for your valuable reply.
I observed that, there's no real problem and all records have been extracted, but the problem was, the row numbers in the table (by which I supposed it contains about 564 records) started by the number 96 instead of 0 and from the code, I numbered records externally i.e inside the loop.
Thank you again.
😃 😃 😃