|
|
|
|  |
 | Re: [PHP] Re: Too many records to display in one web page |  |  |  |
 |
(#11)
|
| Guest Posts: n/a |  Re: [PHP] Re: Too many records to display in one web page -
06-02-2007, 08:56 PM
Very true. I completely forgot to mention that  "Chris" <EMAIL REMOVED> wrote in message news:EMAIL REMOVED... > 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/ |
| |      |
 |  |  |
| |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
