I'm trying to figure ot the avareage age of all users in a certain group.

This is how I calculate 1 user:
PHP Code:
$sql="SELECT * FROM ".$prefix."_users WHERE group = 1";
$result mysql_query($sql);
$row mysql_fetch_array($result)){

$birthday $row['birthday']; // 1970-05-08 //
list($year,$month,$day) = explode("-",$birthday);
$year_diff  date("Y") - $year;
$month_diff date("m") - $month;
$day_diff   date("d") - $day;

'Age: '.$year_diff;

As you can see I calculate the age outside the query... I think I have to doit within the query...

Any help is apreciated...

Thanks in advance ;-)