I have query where one selects an "style" then a "area" and finally "rating". When some selects a rating they select a range of ratings. For example:
Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c
This should pull up all the rock climbs that are in Yosemite, that are traditional style and are between the rating 5.5 to 5.10c. Here is my query:
"SELECT * FROM routes, users WHERE area='$area' AND style='$style' BETWEEN rating='[$rating1]' AND rating='[$rating2]' GROUP BY route ORDER BY rating ASC ";
For some reason which I am not seeing, this query is not doing what it should be doing. Does anyone have any suggestions?
Thanks, Craig
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
