Re: Paging a Recordset
| From: | Web master | Date: | Thu, 15 Mar 2001 20:08:31 +0000 |
| Subject: | Re: Paging a Recordset | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-44113@lists.php.net to get a copy of this message | ||
you can use 'limit x,y' in MySql.
James Crowley wrote:
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 ==================