johnrb87 Posted June 13, 2011 Share Posted June 13, 2011 hi can anyone help me? i have a php form which has 2 fields `age_from` and `age_to` they are both populated with number values (going from 30 to 65). I need to run a query on my database table called `staff` to return those staff members who fall within the age range selected, the only indication of the staff members age is the `dob` field which I also store, and it is in the format "YYYY-MM-DD" can anyone help? im stumped Link to comment https://forums.phpfreaks.com/topic/239180-query-dob-from-user-age/ Share on other sites More sharing options...
PFMaBiSmAd Posted June 13, 2011 Share Posted June 13, 2011 http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html Link to comment https://forums.phpfreaks.com/topic/239180-query-dob-from-user-age/#findComment-1228862 Share on other sites More sharing options...
johnrb87 Posted June 13, 2011 Author Share Posted June 13, 2011 Ok, I built into my query CURDATE(), (YEAR(CURDATE())-YEAR(staff.dob)) - (RIGHT(CURDATE(),5)<RIGHT(staff.dob,5)) AS age which calculates their age, this works ok, but when I try and narrow it down using WHERE age = 50 it returns an error Unknown column 'age' in 'where clause' any idea why? Link to comment https://forums.phpfreaks.com/topic/239180-query-dob-from-user-age/#findComment-1228891 Share on other sites More sharing options...
PFMaBiSmAd Posted June 13, 2011 Share Posted June 13, 2011 Age isn't a column. It is a calculated value assigned to an alias name. Use - HAVING age = 50 Link to comment https://forums.phpfreaks.com/topic/239180-query-dob-from-user-age/#findComment-1228892 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.