Display of number of registered users

Is there an easy way (e.g. a module for J2.5) that shows the number of registered users?

If not, I have sort of figured out how to do this using CB Query Field. I use the following simple query in a field I called 'cb_membercounterquery':

SELECT COUNT( `id` ) FROM `###__users`

I then used the following content substitution in my article:

{cb:[cb:userdata field="cb_membercounterquery"/]}

This works fine if you log in, but for some reason it doesn't work in the Public areas of the site (nothing is displayed) - any ideas why not? I ensured that the field is associated with a Public tab.

Thanks.

Substitutions without a user specified users the viewing user. If you're not logged in then such a user doesn't exist and thus such a field doesn't exist. It's not the most ideal approach, but you can force a user by specifying user="USER_ID" so it'll always display. I however recommend one of the below modules from S4J.

www.software4joomla.com/

If none of the above are sufficient there are plenty of user counters on Joomla.org extension directory.

Okay - will look at what modules they have on offer.

Thanks.

If you find you like any of the S4J modules as a Professional subscriber you can get a discount coupon below.

www.joomlapolis.com/promotions

Even better - thanks again!

By the way, when you said it is possible to use: user="USER_ID", where am I putting this? Is it not recommended because it can cause problems/security issues?

By the way, when you said it is possible to use: user="USER_ID", where am I putting this?

Your substitution. Example as follows.

{cb:[cb:userdata field="cb_membercounterquery" user="42" /]}

Is it not recommended because it can cause problems/security issues?

It's just not the proper way to do it. The query also needs to be more refined. As is it'd count people banned, unconfirmed, unapproved, etc..