Avg Member Age in Statistics?

Anti-Trend · 15-08-2004, 10:03 PM

In the Statistics section of the forum, would it be too difficult to add the average member age to the existing statistics? Not that it's very important, nor 100% accurate (people don't always put their correct BD). I just think it'd be an interesting snippet of info.

Sniper · 15-08-2004, 09:25 PM

interesting, I think I *might* be able to do this my self! though it adds a extra query to the index page!

Anti-Trend · 15-08-2004, 11:43 PM

Sweet

Sniper · 16-08-2004, 12:07 AM

I posted at the vb forums, I will see if I get any replies! I found a code, but gives the avg age of around 1.000 which isnt right!

Anti-Trend · 16-08-2004, 12:22 AM

Quote:

Originally Posted by Sniper

I posted at the vb forums, I will see if I get any replies! I found a code, but gives the avg age of around 1.000 which isnt right!

Hmm, I wonder if that has anything to do with people not including their birthdays at all? I wonder if those cases can be filtered out of the data set...

Sniper · 16-08-2004, 11:47 PM

it sure can be, but not the fake dates? not had a reply at the vbforums yet!

harrack52 · 17-08-2004, 10:48 AM

You can filter.

We could even write the thing ourselves.

Sniper · 17-08-2004, 05:22 PM

heres the code in php/mysql

PHP Code:


			
// average age 
$result=$DB_site->query_first("SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user WHERE YEAR(birthday) <> 0"); 
$age=$result['avgage'];

what it does it take the current year - the average year of birth, which should give the average age!

Sniper · 17-08-2004, 05:44 PM

its ok, I got it!

Edit: Average Age: 25

Anti-Trend · 18-08-2004, 03:04 AM

Nice! Hmm, the avg. age is a little older than I thought it would be.

Sniper · 18-08-2004, 04:29 PM

yeh! but you have to consider people, who have provided a false date of birth!

Addis · 20-08-2004, 08:14 PM

yeah i put my age as 14 now. and i'm 14...now.

Sniper · 20-08-2004, 08:38 PM

thanks dude

15-08-2004, 10:03 PM	#1 (permalink) Top
Anti-Trend Nonconformist Geek Join Date: Oct 2003 Age: 27 Male Posts: 4,884 Times Helpful: 538 Status: Offline My Computer	Avg Member Age in Statistics? In the Statistics section of the forum, would it be too difficult to add the average member age to the existing statistics? Not that it's very important, nor 100% accurate (people don't always put their correct BD). I just think it'd be an interesting snippet of info. __________________ See My Desktop \| Try Linux \| Install Linux \| Visit My Server \| Support Hardware Forums \| Easily rip DVDs in Linux \| Remember Everything

15-08-2004, 09:25 PM	#2 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	interesting, I think I might be able to do this my self! though it adds a extra query to the index page! __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

15-08-2004, 11:43 PM	#3 (permalink) Top
Anti-Trend Nonconformist Geek Join Date: Oct 2003 Age: 27 Male Posts: 4,884 Times Helpful: 538 Status: Offline My Computer	Sweet __________________ See My Desktop \| Try Linux \| Install Linux \| Visit My Server \| Support Hardware Forums \| Easily rip DVDs in Linux \| Remember Everything

16-08-2004, 12:07 AM	#4 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	I posted at the vb forums, I will see if I get any replies! I found a code, but gives the avg age of around 1.000 which isnt right! __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

16-08-2004, 11:47 PM	#6 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	it sure can be, but not the fake dates? not had a reply at the vbforums yet! __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

17-08-2004, 10:48 AM	#7 (permalink) Top
harrack52 Supreme Geek Join Date: Jan 2003 Age: 27 Posts: 1,638 Times Helpful: 16 My Mood: Sick Status: Offline My Computer	You can filter. We could even write the thing ourselves.

17-08-2004, 05:22 PM	#8 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	heres the code in php/mysql PHP Code: `// average age $result=$DB_site->query_first("SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user WHERE YEAR(birthday) <> 0"); $age=$result['avgage'];` what it does it take the current year - the average year of birth, which should give the average age! __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

17-08-2004, 05:44 PM	#9 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	its ok, I got it! Edit: Average Age: 25 __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

18-08-2004, 03:04 AM	#10 (permalink) Top
Anti-Trend Nonconformist Geek Join Date: Oct 2003 Age: 27 Male Posts: 4,884 Times Helpful: 538 Status: Offline My Computer	Nice! Hmm, the avg. age is a little older than I thought it would be. __________________ See My Desktop \| Try Linux \| Install Linux \| Visit My Server \| Support Hardware Forums \| Easily rip DVDs in Linux \| Remember Everything

18-08-2004, 04:29 PM	#11 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	yeh! but you have to consider people, who have provided a false date of birth! __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

20-08-2004, 08:14 PM	#12 (permalink) Top
Addis The King Join Date: Jan 2004 Age: 18 Male Posts: 5,255 Times Helpful: 403 My Mood: Drunk Status: Offline My Computer	yeah i put my age as 14 now. and i'm 14...now. __________________ Never trust a program you don't have the source code for. My website \| Powerful Desktop Linux \| Linux for human beings \| Linux for power users \| Linux for ricers

20-08-2004, 08:38 PM	#13 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 25 Male Posts: 4,434 Times Helpful: 119 My Mood: Bored Status: Offline My Computer	thanks dude __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Official Member Case Gallery	ProcalX	Old Gallery (no posts allowed)	3	15-03-2005 10:27 PM