In the database, I Have DOB table wich is DATE . so I have problem in search function, because I want to search people by Date to be correct age at any time. So fields in search is AGE for example 18-25 , . I want to make searchage1
= 18 in this example and searchage2
= 25.
`dob BETWEEN ".$search_data['searchage1']." AND ".$search_data['searchage2'];`
I want to convert this 18 and 25 into DATE then Compare it to Database DATES . I have tried some possiblity with no sucess, any idea?