confused on how to continue this mysql query

[vishalkhialani]

Hi Guys,
I am looking to query a db having multiple brands of cars then from those results I want to further filter it based on the type of oil they use. I have written the below but it does not work and I am not sure how I can get this done.

I am trying to construct a mysql statement but I can't seem to get it right. I am pretty sure I can't use WHERE twice. Any help will be much appreciated.

SELECT *
FROM `details`
WHERE brand = 'audi' 
OR brand = 'toyota'
WHERE Oil ='Diesel'

[pritaeas]

SELECT * FROM `details` WHERE (brand = 'audi' OR brand = 'toyota') AND Oil = 'Diesel'

[vishalkhialani]

Thanks pritaeas , it worked like a charm

[vishalkhialani]

Hi,
I have a follow up question on this. Say the user selects oil as diesel and the leaves the brand section empty. Then how would I show cars which are based on diesel of all the brands.

The above code works but it only works if the brands are provided. I need to give the user the flexibility to just choice the type of oil too.

Thank you in advance.
Vishal

[pritaeas]

Just remove the (brand = 'xxx') checks.