number of rows returned from SELECT

["Corey" <corey(at)bitworthy(dot)net>]

Hello!

Subject says it all I guess: 

What's the most efficient way of determining the number of rows that 
_would_ be returned after/for a SELECT? Or is this impossible without...
actually... _doing_ a SELECT?

Basically this is for pagination purposes; given a SELECT statement, say,
'SELECT * from table LIMIT 10 OFFSET 10', I'd like to know how many total 
rows would be returned if LIMIT and OFFSET weren't used in the statement.

Basically, same thing this guy was asking for a while ago:
http://www.thescripts.com/forum/thread174930.html


Thanks for the assistance!