I'd go with the query from the forum_stats builder:
Code
$query = "
        SELECT  COUNT(USER_ID) AS COUNT
        FROM    {$config['TABLE_PREFIX']}USERS
        WHERE   USER_IS_APPROVED = 'yes' AND USER_ID > 1
";

And it's possible that one is counting banned or non-approved members.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!