Very true. I completely forgot to mention that :( "Chris" <dmagick@xxxxxxxxx> wrote in message news:465CBC9A.1000802@xxxxxxxxxxxx > 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/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
