I have a form which uses php to populate a list b ox from a mysql column which works great. The problem im having is this If I make more than 1 selection in that list box, and the form that listbox resides in is submitted (using the GET method so I can see which variables are sent). the URL looks like this,
http://www......?poc=fred&poc=john&poc=jake.....
which is right, I'm trying to run a mysql query to ddisplay a table based on those variables. ("select * from company, activity
where c_id = a_c_id and
medivas = '$poc' and
a_date between '$startdate' and '$enddate'
and priority in ('$prioritya', '$priorityb', '$priorityc')
GROUP BY c_name
ORDER BY priority"😉
How do I make it so thaqt when comparing the mmedivas column, it sees all instances of the poc variable, not just 1?
Thanks!