how to move into a recordset?
- From: "chris" <frx@xxxxxxx>
- Date: Tue, 27 Sep 2005 16:13:08 +0200
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
.
- Follow-Ups:
- Re: how to move into a recordset?
- From: Stefan Rybacki
- Re: how to move into a recordset?
- Prev by Date: Re: How to fetch client-information
- Next by Date: Re: Warning: array_merge()
- Previous by thread: How to fetch client-information
- Next by thread: Re: how to move into a recordset?
- Index(es):
Relevant Pages
|
