[Resolved] Multiple Conditionals?

werkkrew

I am making a VERY COMPLEX sql query pulling from 12 different tables to search for Real Estate...

In my advanced search, if they want to limit to one or more specific types of properties, the query needs to perform like:

SELECT * FROM BLAH WHERE blah=blah AND blah2=blah (OR blah3=blah3 OR blah4=blah4) LIMIT 10"

Something like this...

Basically, what I need to know is, the area in which I have enclosed by parenthesis, needs to be several items with OR conditionals whereas the rest need to be AND...

What I have tried so far the OR over rides the AND and it will pull up every property that matches an OR conditional item.

How can I have the query execute the entire set of OR statements included with the rest as an AND?

LordShryku

You should have an AND in front of your OR conditions

SELECT * 
  FROM BLAH 
 WHERE blah=blah 
   AND blah2=blah 
   AND (blah3=blah3 
        OR blah4=blah4) 
 LIMIT 10

tomhath

Trying to join 12 tables together and you don't know how to use AND and OR in the where clause? Good luck 🙁

I'd try to simplify the final query by combining some of the tables into at least two or three VIEWs. Read up on them, you'll probably be able to reuse ones you write in other queries.

werkkrew

I got it to work.

If you are going to post something, try not to make it a criticism, that doesnt help anyone.

My original idea with the parenthesis worked, I just had to change syntax a little bit.

tomhath

I offered a suggestion on how your code can be made simpler, more maintainable, and perhaps reusable. If you don't want to take the advice, don't take it.