Hi,
You can do:
select sql_calc_found_rows [and here follow the rest of the select query];
And then you can get the number of all found rows, not only those got by
"limit 10" as follows:
select found_rows();
Teddy
From: "Grant Giddens" <[EMAIL PROTECTED]>
>
> Hi,
>
> I have a web app whe
Hi,
I have a web app where I am doing a boolean search. I only want
to return 10 results per page, but I'd also like to know how many total
rows match the search query. I'm currently performing this with 2
query statements:
1. (To get the actual rows via the search)
SEL