Posted by chris on 09/27/05 17:13

Hi,

Suppose i need to know the number of records before showing them. With the
first loop, i get the number of records, but I think the pointer in the
recordset remains at the end of the recordset, because the second loop gives
nothing.
Is there a way to put the pointer to the beginning?
The code:
$numofrec=0;
$connect = odbc_connect ('DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=c:\mytable.mdb', '', '');
$query = odbc_exec($connect, "select * from mytable;");
while ($row = odbc_fetch_array($query))
{ $numofrec++; }
echo $numofrecl;

while ($row = odbc_fetch_array($query))
{ $f1 = odbc_result($query, 1 );
....
echo $f1
...
}

Thanks
Chris

• Next in forum: how to move into a recordset?
• Prev in forum: how to move into a recordset?
• Thread view: how to move into a recordset?

[Reply to this message]