Date and mysql query

[stephaneka]

hi
hi have a little prob with a formular

i search to do a query between two age
between 18 (search_age_from) & 30(search_age_to) year for exemple.

My query is going to ask on a db where there is no age field, but a birthday field ( build with the time past since 1970)

In my db so birthday in like this : 1130832000

actually i do the following query :

$query = mysql_query("SELECT FROM WHERE birthday BETWEEN('$search_age_from','$search_age_to') ....

and of course it's not running
Some body can help me to do the good query? i'am newb and have so prob to convert age in good format before doing query

Best regards
Steph

[subwayman]

.... WHERE FROM_UNIXTIME(birthday,'%Y %D %M') BETWEEN....

Change the format paret of FROM_UNIXTIME to what ever format you are using in $search_age_from.