query age

[jansky]

to all guru?

how can i query age using birthday in my table

eg:
id name birthday (date format)
1 name1 1996-12-12
2 name2 1980-11-10
3 name3 1970-09-09

here is the form
<form method="post" action="">
<select start_age>
<option value=10>10</option>
<option value=10>11</option>
<option value=10>12</option>
<option value=etc>etc</option>
</select
<select end_age>
<option value=10>10</option>
<option value=10>11</option>
<option value=10>12</option>
<option value=etc>etc</option>
</select
<input type="submit" name="query" value="Search">
</form>

[thorpe]

your going to need to ask your question more clearly.

do you want to find a users age by querying there birthday stored in a db?

OR

do you want to get an age given a start_age / end_age as your form suggests?

[bretticus]

Well, if I understand the question, I woudl do something like this:

$sql = "SELECT * FROM `birthdays` WHERE  `birthday` BETWEEN DATE_SUB(NOW(), INTERVAL {$_POST['end_age']} YEAR) AND DATE_SUB(NOW(), INTERVAL {$_POST['start_age']} YEAR) ";

That should at least point you in the right direction.