像查询mysql php中的多个值

Question

I have this code:

<?php 
$agenti = $_GET['agenti'];
$agen = array();
if (is_array($agenti)) {foreach($agenti as $val) { $agen[] = "ch.employeename LIKE '" . $val . "'"; }} else {$agen[] = 'true';}

    $raw_results = mysql_query("SELECT distinct ch.employeename, ch.customername, 
                                       ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
                                       ch.groupname, ch.visitdate from chestionare ch
                                    WHERE ch.visitdate >= '".$_GET['from']."' AND ch.visitdate <= '".$_GET['to']."' 
                                    AND (" . implode(' OR ', $agen) . ")
                                    AND ch.customerowner like '$clienti' 
                                    AND ch.class like '$task' 
                                    AND ch.parentgroupname like '$categorie' 
                                    ") 
                                or die(mysql_error());

    if(mysql_num_rows($raw_results) > 0){ 
        while($results = mysql_fetch_array($raw_results)){ ?>

What can I do if $agenti has multiple values (60 values). Values came from another file with <select multiple="multiple"> <option value="test"> test </option>< /select>

Answer 1

If $agenti is dynamic array. Simple example :

$agen = array();

foreach ($agenti as $val) {
    $agen[] = "ch.employeename like '" . $val . "'"; 
}

$raw_results = mysql_query(
           "SELECT distinct ch.employeename, ch.customername, 
               ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
               ch.groupname, ch.visitdate from chestionare ch
            WHERE ch.visitdate >= '".$_GET['from']."' AND ch.visitdate <= '".$_GET['to']."' 
            AND (" . implode(' OR ', $agen) . ")
            AND ch.customerowner like '$clienti' 
            AND ch.class like '$task' 
            AND ch.parentgroupname like '$categorie' 
         ");
or die(mysql_error());