|
|
Joined: Apr 2002
Posts: 474
Enthusiast
|
Enthusiast
Joined: Apr 2002
Posts: 474 |
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
|
|
|
|
Joined: May 2001
Posts: 550
Code Monkey
|
Code Monkey
Joined: May 2001
Posts: 550 |
For the number of users up to the end of august this year, you use 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.
|
|
|
|
Joined: Apr 2002
Posts: 474
Enthusiast
|
Enthusiast
Joined: Apr 2002
Posts: 474 |
Thank's this is what our history is...
2004 - 16,000+ 2003 - 11,165 2002 - 7,560 2001 - 4,795 2000 - 1,210
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 449
Joined: February 2008
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|