Oh, and I assume you left out the part of the query where you bound tables
routes and users?
-P
"Craig Hoffman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "SELECT * FROM routes, users WHERE area='$area' AND style='$style'
> BETWEEN rating='[$rating1]' AND rating='[$rating2]' GRO
I think you want:
"SELECT * FROM routes, users WHERE area='$area' AND style='$style'
AND rating BETWEEN '[$rating1]' AND '[$rating2]' GROUP BY route
ORDER BY rating ASC ";
>From http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
"expr BETWEEN min AND max
If expr is greater than or equal
Date: 8 Apr 2004 09:12:46 -
To: [EMAIL PROTECTED]
From: "David Robley" <[EMAIL PROTECTED]>
Subject: Re: Query Help!
Have you tried
SELECT `username` , `score` FROM round" .
($round_number -1) . " WHERE 1
ORDER BY `score` DESC LIMIT 0, 30
Ahh just tried it and relised what is going
Date: 8 Apr 2004 09:12:46 -
To: [EMAIL PROTECTED]
From: "David Robley" <[EMAIL PROTECTED]>
Subject: Re: Query Help!
[EMAIL PROTECTED] (Jerry) wrote in
news:[EMAIL PROTECTED]:
> Hi Everyone, Happy Easter to you all.
>
> I have this query, reasoning for posting on this
> Mailing List is
[EMAIL PROTECTED] (Jerry) wrote in
news:[EMAIL PROTECTED]:
> Hi Everyone, Happy Easter to you all.
>
> I have this query, reasoning for posting on this
> Mailing List is under it. :)
>
> SELECT `username` , `score` FROM round" .
> $round_number . " WHERE 1
> ORDER BY `score` DESC LIMIT 0, 30
>
