[eluser]WanWizard[/eluser]
Don't think that's what the TS had in mind, as that will give you the number of rows in the result set (i.e. the limited number).
If I interpret the question correctly, this is about a pagination kind of issue, where you need to know the total row count of the table, and a limited set of records for the currently selected page.
Those are two different questions, which you can't answer in a single query.
