Re: [PHP] Paginate any query

Hi, In your mysql query, use the LIMIT keyword at or near to the end of the query. LIMIT 1000 will limit to the first thousand records LIMIT 2000,1000 will retrieve 1000 records, offset by 2000 records. Cheers, Gareth On 17 Feb 2004, at 22:12, Shaun wrote: Hi, I use the following function

[PHP] Paginate any query

Hi, I use the following function to display any query i send to it. Some of these queries produce 1000's of rows and produce an internal server error, is there a way to paginate any query sent to it - say 1000 rows per page? Thanks for your help // query functions function doQuery($query){ i