sql syntax

[chris_davies]

Hello peeps ,
How do I test in MySQL via PHP the sql query for someone's age on a given date? for example, if someone is between 20 and 25 on 1st January 2003? Any help warmly accepted.
Chris

[dhodge]

Here ya are. Uses the unix timestamp from Jan 1 1970 or whatever

$time = time();
$input_time = mktime(0, 0, 0, 1, 1, 2003);  

$difference = $time-$input_time;
$years_since = $difference/31536000;
echo $years;

Get the current time...
Create a unix time for the checking date...
Get the difference...
Divide but the number of seconds in a year...

so you can get basically anything from this.
Seconds=$difference
Minutes=$difference/60
Hours=$difference/3600
Days=$difference/86400
etc...

One thing is that it only works for dates after 1/1/1970...so you could always try and subtract the seconds to get a previous date