Re: WHERE OR Syntax

Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes OR so Also, use 'IN' instead of a series of 'OR' - this will make the query a lot faster. e.g. listings.Area IN ('19','24','25',...) Vadim. JD Daniels wrote: > > I have this query built from a web form. The for

WHERE OR Syntax

I have this query built from a web form. The form will add to the query depending on what search criteria has been chosen. what happens is if they choose the criteria in the query below, it stops comparing the other criteria such as listed date and price range. Also the = operator does not return