query help

[irving]

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'");

[sarahk]

echo out what the php is receiving for $area, each check box could have it's own name, eg opt1, opt2 - it's just in your code that you need to know what they are. Use a naming convention.

then there should be some syntax like

area in ('$opt1','$opt2')

you will need to construct the list.

alternatively you could have

and (area = '$opt1' or area = '$opt2' or area = '$opt3')

I think that the second version will give better performance. Either way you will need to do some work to construct the string based on a changeable set of variables.

By the way is this working?
PRICE <= '$maxprice%' AND items1 >= '$noitems1%'
Not knowing the data or table structure you have I would have thought I could give my maxprice as $100 and it would find things for $1000 but not $200. check this. You should be able to drop the %