Hi all,
In the 4.0 manual, section F.1.1 Changes in release 4.0 it says:
Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many
rows a query would have returned without a LIMIT clause.
Unfortunately, I can't find any other references to FOUND_ROWS() in the
Hi all,
In the 4.0 manual, section F.1.1 Changes in release 4.0 it says:
Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many
rows a query would have returned without a LIMIT clause.
Unfortunately, I can't find any other references to FOUND_ROWS() in the
At 11:21 PM -0500 10/31/01, Robert Alexander wrote:
Hi all,
In the 4.0 manual, section F.1.1 Changes in release 4.0 it says:
Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible
to know how many rows a query would have returned without a LIMIT
clause.
Unfortunately, I can't
My thanks to Paul DuBois, who responded within about a minute of my first posting. :
(Original question below.)
The solution is that SQL_CALC_FOUND_ROWS needs to be included in the original SELECT
query in order for FOUND_ROWS() to have the proper value.
SELECT SQL_CALC_FOUND_ROWS col1, col2