Help needed to Select Count,.

[eluser]Evil Wizard[/eluser]
because like I said if you put a limit on the sql the count(*) will be a count of the resultset not of the possible number of results

EDIT:
I just tested it on MySQL server and yes the count(*) tagged onto the end of the query works just as well and returns number of records that match the where clause but not impeded by the limit