UBB.Dev
Posted By: oceanwest Member counts... - 06/28/2004 6:54 PM
I am getting ready for our annual developer's conference and we have a booth
again. This is our 4th year. And this year I would like to create a banner
with showing our member count each year. To show how much we've grown.

So i guess I need to know what is the proper queries to show me the member
count as of each august 31 for the last 5 years?

Perhaps post / thread totals at that time would be great too.

Thanks
Posted By: Anno Re: Member counts... - 06/29/2004 10:02 AM
For the number of users up to the end of august this year, you use

Code
 SELECT COUNT(*) FROM `w3t_Users` <br />WHERE U_Registered <  UNIX_TIMESTAMP( '2004-08-31 00:00:00') 


Accordingly for other dates, and also for the number of posts.
Posted By: oceanwest Re: Member counts... - 06/29/2004 6:42 PM
Thank's this is what our history is...


2004 - 16,000+
2003 - 11,165
2002 - 7,560
2001 - 4,795
2000 - 1,210
© UBB.Developers