Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

[PHP-DB] Query help From: Craig Hoffman (choffman <email protected>)
Date: 07/09/04

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