Craig-
are you sure you want to test
ranking_id < '10' ???
-martin
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 09, 2004 3:51 PM
Subject: Re: Between Operator
> Than
At 05:51 PM 7/9/2004, you wrote:
Thanks everyone for helping out.I took Michael's advice and made a
new table called ranking and two columns. It defiantly cleared some
things up but I am still having issues using the BETWEEN operator. I
just need to pull up everything BETWEEEN 10 and 18 a
Thanks everyone for helping out.I took Michael's advice and made a
new table called ranking and two columns. It defiantly cleared some
things up but I am still having issues using the BETWEEN operator. I
just need to pull up everything BETWEEEN 10 and 18 and it keeps adding
additional ro
On Fri, Jul 09, 2004 at 09:39:02AM -0500, Craig Hoffman wrote:
> Style: Traditional
> Area: Yosemite
> Rating: From: 5.5 To: 5.10c
...
> "SELECT * FROM routes, users WHERE area='$area' AND style='$style'
> BETWEEN rating='[$rating1]' AND rating='[$rating2]' GROUP BY route
> ORDER BY rating ASC
On Fri, 09 Jul 2004 11:38:05 -0400, Keith Ivey <[EMAIL PROTECTED]>
wrote:
Craig Hoffman wrote:
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'
Craig Hoffman wrote:
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
