Re: Re: Too many records to display in one web page

Steve wrote:

The way I handle it: Step 1- Add SELECT SQL_CALC_FOUND_ROWS to the front of your initial query and add the pagination limit to the end (LIMIT 200, 400 or whatever range you want to display.) Step 2- Do a 2nd query: SELECT FOUND_ROWS() immediately after.

With a *HUGE* clause that this only works with mysql. There are other databases out there :P -- Postgresql & php tutorials http://www.designmagick.com/