Where clause help

[gigabyt3r]

Hi I was wondering if anyone could help me, I have a problem with the following query and , if a vehicle has "Chassis Based Vehicle Sales" in Vehicle Type 1 or Vehicle Type 2 then it will show up on the results page. But if it is in Vehicle Type 3 then nothing is shown, is there a problem with my syntax?

 

The code doesn't bring up any errors.

 

Here is the code,

 

 

 

 

 

 

SELECT vehicles.`Image Prefix`, vehicles.`Vehicle Registration`, vehicles.Mileage, vehicles.Transmission, vehicles.Color, vehicles.`Fuel Type`, vehicles.Make, vehicles.Model, vehicles.`Reg Year`, vehicles.ID
FROM vehicles
WHERE vehicles.`Vehicle Type`= \"Chassis Based Vehicle Sales\" OR vehicles.`Vehicle Type 2` = \"Chassis Based Vehicle Sales\" OR vehicles.`Vehicle Type 3` = \"Chassis Based Vehicle Sales\" AND ID = colname
ORDER BY vehicles.`Registration Prefix` DESC

 

 

 

Thanks in advance

[tivrfoa]

try with parenthesis:

 

SELECT vehicles.`Image Prefix`, vehicles.`Vehicle Registration`, vehicles.Mileage, vehicles.Transmission, vehicles.Color, vehicles.`Fuel Type`, vehicles.Make, vehicles.Model, vehicles.`Reg Year`, vehicles.ID
FROM vehicles
WHERE (vehicles.`Vehicle Type`= \"Chassis Based Vehicle Sales\" OR vehicles.`Vehicle Type 2` = \"Chassis Based Vehicle Sales\" OR vehicles.`Vehicle Type 3` = \"Chassis Based Vehicle Sales\") AND ID = colname
ORDER BY vehicles.`Registration Prefix` DESC

[fenway]

Try without spaces in your field names!!!!!