My users can search for an order by an address right now. What I would like to do is let them be able to search with multiple criteria. Let them search by address, city, state, etc etc.

I have tried using the following code, but it doesn't seem to work.

```
$sql = ("SELECT order_number, sitestreet FROM  `PropertyInfo` WHERE  `sitestreet` LIKE '%$street%' OR `sitecity` LIKE '%$city%' AND `user` LIKE '$user'");

$result = mysql_query($sql);

```

I don't think it's reading the value in $user cause it displays all orders for all users.

How can I make it possible to search for an order using multiple serach values?

Thank you!