Very true. I completely forgot to mention that :(
"Chris" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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,
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 th
2 matches
Mail list logo
