pager related issue

I am working on a pager class that relies on a standard statement like: select * from my_table limit $offset, $limit As a feature of my pager class, I would like to display the total number of pages (each one of $limit rows) to display and the current page number. Does anybody use any clever trick other than performing an additional query like "SELECT COUNT(*) WHERE.." ? any suggestion is welcome. thanks alessandro