Sql "or"

[Mister]

I'm trying to get the following query to work but I can get the "or" operator to work:

any ideas would be much apreciated.

$query = "SELECT
news_id,
news_cat_id,
news_title,
news_keywords,
news_content,
DATE_FORMAT(news_date, '%D %b %Y') AS news_pubdate,
news_image_name,
news_region_id,
region_title
FROM news_tbl, region_tbl
WHERE news_region_id = 6 OR 1
AND region_id = news_region_id
AND news_date > DATE_SUB(CURDATE(), INTERVAL 3 DAY)"

[njm]

Try:

...
WHERE news_region_id = 6 OR news_region_id=1
...

or alternatively,

...
WHERE news_region_id IN (1,6)
...

hth, njm

[Mister]

Your a star. Cheers