|
|
Posted by Stefan Rybacki on 09/27/05 17:58
chris wrote:
> 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
>
>
There should be a function like odbc_num_rows
Regards
Stefan
Navigation:
[Reply to this message]
|