Query help

[sidsel]

I got a query:

select * from table where partner = '$partner' AND day='$date' AND checksales1='1'

Works fine...

Now I have added a new colum to my table: checksales2
I wish to use the same query above but with a OR included like: checksales1='1' OR checksales2='1'

But if use this query it does not work:
select * from table where partner = '$partner' AND day='$date' AND checksales1='1' OR checksales2='1'

How do I format it correct?

[sidsel]

It works if I put it in brackets but is this the right way?

select * from table where partner = '$partner' AND day='$date' AND (checksales1='1' OR checksales2='1')

[_0_05_]

perhaps you have to signify somehow that you want to compare only checksales1 and checksales2 with that OR statement... maybe try brackets??

edit: ha, you replied as i was replying 😃