[RESOLVED] Convert date of borth in Mysql field

kbc1

I have a form which allows a user to search for people and a form element is a jquery slider which allows the user to choose an age range.

So the user may choose to search for 18 to 27 year olds only as an example.

Now, the people records stored in the database have a date of birth field stored as (e.g.) "1970-01-01".

So my question is, is there a good way of getting/calculating the DB records that meet the date range selected directly in the MySQL query based on calculatingback from todays date?

I hope that makes sense!

kbc1

Ive sorted it.

It came to me the second after I posted it!

$min_date = strtotime("-XX years", $todaysdate);

bradgrafelman

I would think a better solution would be to just do it all in the query, e.g.:

WHERE dateCol BETWEEN CURDATE() AND (CURDATE() - INTERVAL xx YEAR)