performing search by age - mysql table

[taya]

Hello

Here's the thing i'm trying to figure out and would much appreciate any help:

I want to make a search page - search by age.

in MySQL database i have a column birthdate which contains birthdates in th mysql format: YYYY-MM-DD

how can i calculate the age in PHP and then put the search results in the HTML format?

I already had a look at ready scripts but as far as i understand they take teh MYSQL columns which contain month and year separately, not like YYYY-MM-DD

thanks!

[planetsim]

Ive never done this, but i will be sometime within the next few months for a project im doing.

Anyway..

What id do would be first
extract the data from the database..

so YYYY-MM-DD which could be 1999-09-12

Then from there use explode

$date = $r['bday']; //bday being the YYYY-MM-DD Feild
$data = explode("-",$date);//We now have 3 seperate bits of data.

From there its simple maths. First working out the Month and Comparison to the current month, then Year and then day. You'd probably make the year last.

You'll have left over data from that ofcourse.
If this doesnt seem easy enough to do, you could probably use the same method to start then use mktime to work it out.