Oh, and I assume you left out the part of the query where you bound tables routes and users? -P "Craig Hoffman" <choffman@xxxxxxxxxx> wrote in message news:9D92FF2A-D1BC-11D8-A573-0003935B61DA@xxxxxxxxxxxxx > "SELECT * FROM routes, users WHERE area='$area' AND style='$style' > BETWEEN rating='[$rating1]' AND rating='[$rating2]' GROUP BY route > ORDER BY rating ASC "; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php