Paging a Recordset
| From: | James Crowley | Date: | Thu, 15 Mar 2001 18:50:00 +0000 |
| Subject: | Paging a Recordset | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-44096@lists.php.net to get a copy of this message | ||
Hi,
I want to spread the results of a recordset over a number of pages. In ASP,
I would have opened a connection with a client-side cursor... but with PHP
(using it's ODBC functions), it only seems to be able to execute an SQL
statement, and return all the results... which isn't very efficient if I
have 500 results with 10 per page!
Also, how do I change the cursor location?
Regards,
- James
Editor, VB Web
==================
Web - http://www.vbweb.co.uk
Email - james@vbweb.co.uk
ICQ# - 60612011
==================