Query ????

[joeywoodbury]

Ok once again the I cannot find the logic. I need this query to give the user the ablilty to only search for one of the items and not have to complete the entire search criteria. They also need to be able to live all of the form blank, hit search and have it return everything in the database.

I would like to have a list of logical operators such as AND, LIKE, and OR. And when I should use them. I fould some documentaion on php.net, but was not enough for my rookie brain to process.

Thanks to anyone in advance who helps me. It is much appreciated.

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

[Anon]

First, you have to decide what will be passed in when the user leaves a field blank. I'll assume a single space, but you can use anything you prefer. Then it's a simple matter of matching on what they entered or taking anything if the blank was entered:

SELECT * FROM $usertable
WHERE (price >= '$minPrice' OR '$minPrice' = ' ')
AND (price <= '$maxPrice' OR '$maxPrice' = ' ')
AND so on... I'm sure you see a pattern here.

[Anon]

That worked on all of them except the maxPrice, it is still requiring me to enter data into that text field. It is the only one that is checked twice by the query to determince if the the price if in between the $maxPrice and $minPrice. Any suggestions?