jnull
-
Posts
4 -
Joined
-
Last visited
Never
jnull's Achievements
Newbie (1/5)
0
Reputation
-
Thank you ... just perfect!
-
I have the following select statement: SELECT * FROM `events` WHERE `Category` = "one" OR `Category` = "two" OR `Category` = "three" AND (`StartDate` BETWEEN "2011-06-30" AND "2011-07-05") ORDER BY `Category` It returns data for all date ranges in the categories specified, which is incorrect. If I only have SELECT * FROM `events` WHERE `StartDate` BETWEEN "2011-06-30" AND "2011-07-05" ORDER BY `Category` it returns nothing which is correct response. Can you give me any idea of what's up with the first select statement?