I have a form with;
list box where multiple selections can be made, name is medivas_poc
group of 3 checkboxes where a priority is selected; A, B, and C, names are prioritya ....
2 combo boxes so a date range can be selected, name is startdate and enddate,
lastly I have a combo box so a certain company can be selected, name is c_name
The query so I could find the results from all the selections made is this (soo far)
Select * from company, activity where medivas = $medivas_poc and priority in ($prioritya, $priorityb, $priorityc) and a_date between ($startdate, $enddate) and c_name = $C_name

Is this right and how do I change it so it will work even when multiple selections could be made from the first list box?


Thanks.