Count how many users there are

[eluser]jtotheb[/eluser]
hi,

i would like to use active record to build a select query, and then return the volume of that query in my view.

I wish to show how many users are registered in something i am practicing building with CI!

I tried using mysql_num_rows but that didn't work!

Any help would be very gratefully received.