-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Juleni wrote:
> Hello Brent,
>
>Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS
> within my SELECT query (and I also didn't use SELECT COUNT(*) ... query).
>But when I used SQL_CALC_FOUND_ROWS and then I retrieved number o
First you are using two distinct queries where you should be using two
"related". Specifically, add SQL_CALC_FOUND_ROWS to your first query
that retrieves data, then issue a query to see how many rows you would
have had if you hadn't specified a LIMIT:
SELECT FOUND_ROWS()
The second query sh
