Posted by Justin Koivisto on 01/30/06 21:44

comp.lang.php wrote:
> Dangit I thought I could do THIS simple task today and even this is
> beyond me!! :(

If you're using mysql to get the "birth" field, why not add a field in
the query:
FLOOR((CURDATE() - DOB)/10000) AS age

> [code]
> <?= date(time()) - date(strtotime($result[0]->birth)) ?>
> [/code]
>
> This is completely wrong, but what IS right? I'm stumped!

This depends on how your server handles timestamps. For instance, does
it support negative ones (before 1970)? I've found using SQL queries to
calculate age generally work much better as it seems to be consistent
between platforms/servers.

--
Justin Koivisto, ZCE - justin@koivi.com
http://koivi.com

• Next in forum: Which installer is better?
• Prev in forum: Re: Newbie needs a workaround - No Cron Jobs on Godaddy shared server!
• Thread view: Re: How do you get someone's age from DOB?

[Reply to this message]