mySQL query help

[SJH]

I have the following mySQL query to run on my database using PHP It basically pulls out all article titles with a certain category and subcategory from the 'articles' table to display on the page.

SELECT * FROM articles WHERE category = 'cars' AND subcat = 'events' ORDER BY id DESC 

But I want to be able to select a row that meets the following criteria:

Category = cars
Subcategory = events OR tech

I have tried this:

SELECT * FROM articles WHERE category = 'cars' AND subcat = 'events' OR subcat = 'tech' ORDER BY id DESC 

But this also selects other rows with other categories.

Can anyone point me in the right direction here?

[pippo]

Hi,

You need to add ( ) brackets:

SELECT * FROM articles WHERE category = 'cars' AND  ( subcat = 'events' OR subcat = 'tech' ) ORDER BY id DESC 

[vgarcia]

Originally posted by pippo
Hi,

You need to add ( ) brackets:

SELECT * FROM articles WHERE category = 'cars' AND  ( subcat = 'events' OR subcat = 'tech' ) ORDER BY id DESC 

Or you can use the SQL IN function!

SELECT * FROM articles WHERE category = 'cars' AND subcat IN('events', 'tech') ORDER BY id DESC 

Hopefully that works!

--Vinnie

[SJH]

Thanks guys.

I used the first solution in the end, works fine

-Sam