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 Quote 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 Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.