Average Age

[pgowder]

I'd like to compute the average age of my users for statistical information.

Any ideas on how to write this query?

[Admin]

The query:
SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user;
You might want to round() it later, or you can do it directly in the query using MySQL's ROUND() function, for example:
SELECT ROUND(YEAR(NOW())-AVG(YEAR(birthday)),2) AS avgage FROM user;
will round it to 2 decimal points.

[pgowder]

How can I eliminate the ones that didn't input a year?

[Psychdrone]

wow sweet!

Where would I put this code and where would I recieve the results!

[FWC]

[QUOTE]Originally posted by pgowder
How can I eliminate the ones that didn't input a year?

[pgowder]

Here is what I tried:

[QUOTE]SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage
WHERE birthday != 0000-00-00 FROM user

[FWC]

After FROM user:

SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user WHERE birthday != 0000-00-00That doesn't error, but I got a strange result. My average user is 216 years old. :)

I think it may be because we are excluding the the unset year cells but the total rows aren't changing when the average is calculated.

[Psychdrone]

could someone answer me please!

Thanks!

[Freddie Bingham]

SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user WHERE YEAR(birthday) <> 0I wasn't aware of the YEAR() function, I will have to check that out.

[FWC]

[QUOTE]Originally posted by freddie
SELECT YEAR(NOW())-AVG(YEAR(birthday)) AS avgage FROM user WHERE YEAR(birthday) <> 0I wasn't aware of the YEAR() function, I will have to check that out.

[pgowder]

That works, thanks guys!

[Admin]

Don't I rock as well? :(

[Freddie Bingham]

NO, only I do!

[Lesane]

hmmm......this is my result: Array :confused:

[Admin]

[QUOTE]Originally posted by freddie
NO, only I do!

[djr]

whoa, my users are old :-) (32.3151 average)

- djr

oops, accidentaly clicked 'new thread' instead of 'new reply'.
Please move this to https://vborg.vbsupport.ru/showthread.php?s=&threadid=33554

thanks and sorry

- djr

[Lesane]

Aight, Thanks Firefly

[FWC]

[QUOTE]Originally posted by FireFly
Don't I rock as well? :(

[Freddie Bingham]

[QUOTE]Originally posted by FWC
Yeah, but I tell you and Bira "you rock" all the time. :)

I don't get as many chances with Freddie. :)

[FWC]

[QUOTE]Originally posted by freddie
No need. I will get enough of that when v3 is released ;) Then that will quickly be followed by "you suck, why did you change that???".

[Psychdrone]

you all rock! :rolleyes:

Could someone help me out with my question please!

[Lesane]

Psychdrone, add this in your index.php:

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

And put $age in your forumhome template

[merk]

[QUOTE]Originally posted by freddie
No need. I will get enough of that when v3 is released ;) Then that will quickly be followed by "you suck, why did you change that???".

[DannyITR]

I get Null as an answer. Does this work for VB gold?