calculate age from date of birth

[MDanz]

i have date of birth stored as DATE type in mysql.  i tried this so it would show the age but it comes up blank.

 

$getprof = mysql_query("SELECT * FROM Profile WHERE username='$search'")or die(mysql_error());

 while($rowprof = mysql_fetch_assoc($getprof))
{

$username1 = $rowprof['username'];
$location = $rowprof['location'];
$gender = $rowprof['gender'];
$dateofbirth = $rowprof['dateofbirth'];
$information = $rowprof['information'];
}

function GetAge($dateofbirth)

{

        // Explode the date into meaningful variables

        list($BirthYear,$BirthMonth,$BirthDay) = explode("-", $dateofbirth);

        // Find the differences

        $YearDiff = date("Y") - $BirthYear;

        $MonthDiff = date("m") - $BirthMonth;

        $DayDiff = date("d") - $BirthDay;

        // If the birthday has not occured this year

        if ($DayDiff < 0 || $MonthDiff < 0)

          $YearDiff--;

        return $YearDiff;

}

echo $YearDiff;

[JasonLewis]

Take a look at this topic, and the reply by Barand.