need help forming sql statement

[HelenDev]

I need to make a sql statement but I am not getting it quite right. I want ONE statement to ask for both of these things...

$query1 = "SELECT * FROM products WHERE category ='home_cinema_audio' ";

$query2 = "SELECT * FROM products WHERE category ='hifi' AND brief_desc LIKE '%usb%' ";

I tried this...

$this_query = "SELECT * FROM products WHERE category ='hifi' AND brief_desc LIKE '%usb%' OR WHERE category ='home_cinema_audio'";

...but it gave an error. Does anyone know how I should properly form this query?

(these snippets are just part of the bigger code - I know that all the db connection stuff etc works fine)

[tomda]

Not sure but try this

$this_query = "SELECT * FROM products WHERE (category ='hifi' AND brief_desc LIKE '%usb%') OR category ='home_cinema_audio'";

Tomda

[HelenDev]

Great stuff tomda, it works.