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

Very true. I completely forgot to mention that :( "Chris" <dmagick@gmail.com> wrote in message news:465CBC9A.1000802@gmail.com... > 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/