1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
foreach ($_POST['checkbox'] as $checkbox){
$values[]=$checkbox;
}
$arrlength=count($values);
if ($arrlength=='1'){
$sql_critere= " AND defaut='$values[0]'";
}elseif ($arrlength=='2'){
$sql_critere= " AND defaut in($values[0],$values[1])";
}else{
$sql_critere= "";
}
$result = mysql_query("SELECT * FROM afficher,doc WHERE afficher.idqrqc = doc.idqrqc $sql_critere order by titre ", $cnx)
or
die("Pb dans la requête : " . mysql_error($cnx));
echo "SELECT * FROM afficher,doc WHERE afficher.idqrqc = doc.idqrqc $sql_critere order by titre "; |