I am having problems with a MySQL query. I use the following query:
SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND
users.ID=search_users.ID AND search_users.Login<>'' AND search_users.LookForSex="M"
AND search_users.Sex="F" AND search_users.Country="US" AND search_users.State="CA"
AND ( search_users.Age>=30 AND search_users.Age<=40 ) ORDER BY search_users.Age
and I get 36 rows returned for an age range of >=30 and <=40
but if I use this query:
SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND
users.ID=search_users.ID AND search_users.Login<>'' AND search_users.LookForSex="M"
AND search_users.Sex="F" AND search_users.Country="US" AND search_users.State="CA"
AND ( search_users.Age>=35 AND search_users.Age<=35 ) ORDER BY search_users.Age
and I get 45 rows returned for an age range of >=35 and <=35 !!!!!
The queries are exactly the same except for the age ranges!!! But it is giving me
inaccurate results.
Any light that you can shine on this matter will be helpful,
Thanks,
Jonathan Almarez
