filtering birthday that is only

[jansky]

to all guru

1. I have a one form (conf_rel.php). What this does is makes settings for categories. And also the settings are the followings. you can select on drop down. I will not post everything the codes since it is only HTML but basically this is the selections

   < type="text" name="name">
   <select name='birthmonth'><option value=1>1</option>.....to 12</select>
   <select name='birthday'><option value=1>1</option>.....to 30</select>
   <select name='startage'><option value=1>1</option>.....to 80</select>
   <select name='endage'><option value=1>1</option>.....to 80</select>

   upon savings it store it a table

   mysql_query("insert into settings (birthmonth,birthday,startage,endage,name) values ($birthmonth,$birthday,$startage,$endage,'$name')");
   

upon saving it i can select members meet that criteria the question is how can i select all members that fall in that criteria. in my table i dont have age field i only have birthday field (year-day-month)

[devinemke]

first of all, don't store the DOB as two separate fields, store is as a single DATE field. secondly, what is the purpose of the startage and endage fields?

[jansky]

the purpose of the age is to group members belong to
example:
birthmonth=5 "which is May"
birthday= 15
startage=10
endage=20

So what will happen now is this. It will display all members that his/her age is in between 10-20 and born after May 5 . The year is not important for this