if you are capturing date of birth of the applicant then you can infer the age. assuming you have a drop down with the age e.g. from 18 to 55 then you can easily extract the data using the sample code below

$age = intval($_POST["age"]); // posted age e.g 18;
$sql = "select * from applicants where qualification = 'selected Qualification' and year(now()) - year(dateofBirthOfApplicant) = $age ";



On Tue, Dec 22, 2009 at 6:50 AM, Calvin Omari <calvinebarongo@gmail.com> wrote:
Hallo Guys,

I am implementing a n online job application and in the back end I need a search criteria i= to search applicants by Position applied, Search by qualification e'g drop down with Bsc Comp science etc,  and search by age which right now does even appear feasible to me as i have a field called date of birth of course we cant put age in the db

Any suggestion link sample code will do me a lot of good

Regards and Merry Xmass and a happy new year

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
Other lists
-------------
Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science:  http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi:     http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general