Calculating Age

[jamescrawley]

I have a script I got out of a book that takes a day ($day), a month ($month) and a year ($year) for a date of birth and then outputs the persons age. However if the year is before 1970 the age is always 32. The script uses a timestamp, do these only work on Unix (I am running Windows)?
Is there another simple, short way of doing this?

Cheers.

[Gordon Gekko]

I know that the UNIX timestamp was created 1970 ....

[redgoals]

try this

<?
$result = mysql_query("SELECT DATE_FORMAT(date, '%Y') AS mydate from table");
$myrow = mysql_fetch_array($result);
$year = $myrow["mydate"];
$today = date("Y");
$age = $today - $year;
echo "$age years old";
?>

[jamescrawley]

Cheers redgoals

I adapted the code you posted to take into account the day and month and it does the job fine.

Thanks again.