I have the following query and my problem is that variable 'area' could have multiple values passed from a checkbox form.
How could I accomplish this? Do I need to create an array list from the checkbox selections and if so what would the syntax be for the array in my query?
$result = mysql_query ("SELECT * FROM Mytable WHERE PRICE >= '$minprice%'
AND PRICE <= '$maxprice%' AND items1 >= '$noitems1%'
AND items2 >= '$noitems2%' AND area = '$area1'");
