Hey Everyone,
I can use some help here.... I have query where one can selects an "style" then a "area" and finally "rating" through a drop menu. 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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to