[RESOLVED] Where x = 1 OR x = 2 BETWEEN RecordDate

blackbox

Hi all,
I am working on a small query that looks up the value of a column and if the "RecordDate" is between two dates return the result.

This is a simple query but I have totally lost the plot.

WHERE Col1  = 1 || Col1 = 2 AND RecordDate BETWEEN '" .$_POST['FromDate'] . "' AND '" .$_POST['ToDate']."'

I know this is not right because the returned result is all records where Col1 = 1 || Col1 = 2 but not in the date range.

Can anyone advise please.

Cheers,

Blackbox

sneakyimp

Seems to me you should use parentheses to group your WHERE clause conditions. I think your query is saying "get me records where col1=1 OR..........col1=2 and RecordDate in the range blah blah." Does that make sense? I vaguely recall that operator precedence has something to do with this.

Maybe try this:

WHERE (Col1  = 1 || Col1 = 2) AND RecordDate BETWEEN '" .$_POST['FromDate'] . "' AND '" .$_POST['ToDate']."'

Another possibility is that your RecordDate column in your db table is not a Date but maybe a varchar instead. That can result in some weird behavior because the date values will be evaluated as strings.

blackbox

sneakyimp;11051355 wrote:
Seems to me you should use parentheses to group your WHERE clause conditions. I think your query is saying "get me records where col1=1 OR..........col1=2 and RecordDate in the range blah blah." Does that make sense? I vaguely recall that operator precedence has something to do with this.

Maybe try this:
WHERE (Col1  = 1 || Col1 = 2) AND RecordDate BETWEEN '" .$_POST['FromDate'] . "' AND '" .$_POST['ToDate']."'
Another possibility is that your RecordDate column in your db table is not a Date but maybe a varchar instead. That can result in some weird behavior because the date values will be evaluated as strings.

Hi sneakyimp,

Bang on the money. Many thanks.

sneakyimp

Glad I was able to help.