Finally I have decided how to get the real age of users using mysql:


SELECT YEAR(NOW()) - YEAR(birthday) - IF ( MONTH(NOW()) < MONTH(birthday), 1, 0 ) - IF ( MONTH(NOW()) = MONTH(birthday) AND DAYOFMONTH(NOW()) < DAYOFMONTH(birthday), 1, 0) AS age, birthday, now() from profile where id = 37;


Any comments? :)