Re: subtracting dates...
| From: | Craig Roberts | Date: | Sat, 02 Aug 2003 19:37:52 +0000 |
| Subject: | Re: subtracting dates... | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-29637@lists.php.net to get a copy of this message | ||
Try something along the lines of
if($current_MM < $MM) {
$age = $calculatedage - 1;
}
you'll also need to do something like this with the day of the month if the
user's bday is in the current month.
at least... i think that works out :$
Craig Roberts
"John Ryan" <celticfc@iol.ie> wrote in message
news:20030802192952.32960.qmail@pb1.pair.com...
> Hi,
>
> 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?
>
>