$sql="SELECT AVG(YEAR(NOW()) - YEAR(u.birthday)) AS avg_age FROM ".$prefix."_club_users cu
INNER JOIN ".$prefix."_users u ON cu.new_userid = u.new_userid
WHERE clubid='$umode' AND cu.active=0";
$result = mysql_query($sql) or die("Error: (" . mysql_errno() . ") " . mysql_error());
$row = mysql_fetch_array($result);
Sorry, one record was wrong (000-00-00). Everything works fine with query below… But is there a way to not count the ones with 0000-00-00?
$sql="SELECT AVG(DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(u.birthday_new, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(u.birthday_new, '00-%m-%d'))) AS avg_age, COUNT(*) as count FROM fb_club_users cu
INNER JOIN ".$prefix."_users u ON cu.new_userid = u.new_userid
WHERE cu.clubid='$groupID' AND cu.active=0";