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
Thanks everyone for helping out.I took Michael's advice
Hey Everyone,
I have query where one selects an style then a area and finally
rating. 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
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
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'
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 ;
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
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
Description:
This is a simple bug with dates and 'between' operator. Full data is
supported below, but for the start I show the very essence of the problem. I
use the latest stable version of MySQL - 3.23.52.
SELECT weeks.ix FROM team, weeks WHERE
team.ix=6 AND
weeks.start team.ctime