Try this (taken from

*menaurus at gmx dot de*
16-Jul-2003 02:37       
|The argument has to be in the standard mysql format (y-m-d)...

function age($date) {

if (!$date) return false;

|if ($month<$m) $t=-1;
else if ($m==$month AND $day<$d) $t=-1;|||

return ($age+$t);

Good luck.


John Ryan wrote:


In mySQL, I store dates as YYYY-MM-DD, a standard DATE type. It stores users
date of births. I need to calculate in a PHP script, the users age from this
DOB. I get a PHP date in the same format as the mySQL and subtract, which
returns the year rounded off. ie, it doesnt matter if your birthdays in june
of 1983 and the date is januray 2003, your age is still returned as 20, when
it should be 19.

Does anyone know how can i get the right age?

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to