I have a mysql query that I am trying to write, here is the query as it stands now:
SELECT * FROM videolist video , videotocat channel WHERE (channel.id = video.id) AND (cid = 1) AND OR (cid = 3)
This returns no results
But if I run:
SELECT * FROM videolist video , videotocat channel WHERE (channel.id = video.id) AND (cid = 1)
or
SELECT * FROM videolist video , videotocat channel WHERE (channel.id = video.id) AND (cid = 3)
I get results...
Am I using the wrong syntax?