获取多个ID，同时将多个选择选项值POST到下一个表单

Question

how can I get multiple ID while POST multiple selection option value to next form? I only get the first selection ID from array. Can you guys can suggest any ideas to me?

here is my code when select the value.

 <tr>
                  <label>Auditor: </label>
                     <select class="form-control" name="auditor[]" multiple="multiple" >
                    <?php 
                    $result =  $db->query("SELECT * FROM auditor"); 
                    while($row = mysqli_fetch_array($result))
                    {
                        echo '<option value="'.$row["auditor_name"].'">'.$row["auditor_name"].'</option>';
                        }   
                    echo "</select>";
                    ?>
                  </tr>

here is another code while POST to the next page.

$myselected         =   $_POST["auditor"];

if(count($myselected)>1){
    $auditor = implode ("','",$myselected);
    }else{
    $auditor =$myselected;
    }

$query10 = "SELECT * FROM auditor WHERE auditor_name IN ('$auditor') ";
$result10 = $db->query($query10);
$row10 = $result10->fetch_array();

?>

<form action="audit_action/audit_action.php" role="form" method="post" name="auditformdetails" onsubmit="return(validate());">  
<table width='100%' border='0' class="table">
<tr>
    <td colspan=6>Audit details</td>
    <td colspan=6>Outlet details</td>
</tr>

<tr>
<td><b>Auditor:</b></td>

<td colspan='5'>
**<?php 
    echo'<input type="hidden" name="auditor_id" value="'.$row10["id"].'">';

    foreach ($myselected as $auditor){ 
    echo $auditor."<br>
"; 
    }
?>**
</td>

Answer 1

You can not compare string with mysql IN Clause. So, you have to connect each of your value with or condition in query as i written below.

$myselected  =   $_POST["auditor"];
$sql_cond = "";
if(count($myselected)>1){

    foreach($myselected  as $selected){
        if($sql_cond != "")
          $sql_cond.=" or auditor_name = ".$selected;
        else 
            $sql_cond.=" auditor_name = ".$selected;
    }

}else{
     $auditor =$myselected;
}

$query10 = "SELECT * FROM auditor WHERE ".$sql_cond;