Multiple Query Help

[joeywoodbury]

This query is not searcing the DB correctly. The minimum price and max price is wrong. It is giving me everything in the DB and not just a range of min and max. PLEASE HELP! Thanks in advance for you time. I can't seem to find any tutorials out there on a query like this.

$query = "SELECT * FROM $usertable WHERE price > '$minPrice' AND price < '$maxPrice' OR quanBed LIKE '%$quanBed%' OR quanBath LIKE '%$quanBath%' AND propertyid LIKE '$propertyid' AND brokerid LIKE '$brokerid' ORDER BY price ASC, homeid ASC";

[Anon]

I would guess the biggest problem is that SQL has no idea how you want your and's and or's broken up. You need to add some parentheses so that it knows how to group stuff. Also, you should use '=' instead of 'like' if you are not using any wildcards.

Your query could be rewritten like:

$query = "SELECT * FROM $usertable WHERE (price > '$minPrice' AND price < '$maxPrice') and (quanBed LIKE '%$quanBed%' OR quanBath LIKE '%$quanBath%' AND propertyid = '$propertyid' AND brokerid = '$brokerid') ORDER BY price ASC, homeid ASC";

Of course, I have no idea if that is what your logic should be. Impossible for me to tell.

Good luck.

[joeywoodbury]

Thanks for that info. Basicly the logic is, they don't have to search on all the criteria, so if the only want to search on one part of the crieteria the can. Or if the want to fill out the entire search form the can also do that to narrow down the search.

Again thanks for your input and I will try that out.