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
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.
What does this do?
It will return your
I am developing a web site that interacts with a MySQL database. When I
run
a query and display the records in a web page, this can become a problem
because there might be too many records to be displayed in one single web
page so I am trying to divide the total number of records and display the
4 matches
Mail list logo
