After you execute your select/limit statement you can execute
select found_rows()
It returns the number of rows thbat the previous query would have returned
if the limit wasn't applied. See:
http://dev.mysql.com/doc/mysql/en/information-functions.html.
Regards,
E
> Hi everyone, Im executing the following query:
>
> SELECT *
> FROM
> table1
> WHERE
> table1.field1 = 'A' AND table1.field2 = 'B'
> LIMIT 0,10
> I also need to get the total record count for the above query, but
> without the limit clause (limit is for pagination purposes)
> Is there any way to extract this total record count without the need
> to
> do another query?
> Right now I am using another query to get the total record count:
>
> SELECT COUNT(*)
> FROM
> table1
> WHERE
> table1.field1 = 'A' AND table1.field2 = 'B'
> In reality, my tables are very large, and involve joins, so executing
> the query TWICE is taking its toll on the server.
> Thanks!
> Pow
