$peerquery = "SELECT * FROM peerprosg where ";
$i=1;
foreach ($checkbox1 as $a) {
if($i !=1 ) $peerquery .= "or peer = '$a'";
else $peerquery .= " peer = '$a'";
$i++;
}
$i=1;
foreach ($checkbox1 as $a) {
if($i !=1 ) $peerquery .= "or peer = '$a'";
else $peerquery .= " peer = '$a'";
$i++;
}
in ('".$checkbox1."')
这个程序的主要难点是,跟据查询的字段名是数组里的值,而且以or的方式查询,如,我设查值都是1$peerquery = "SELECT * FROM peerprosg where checkbox[1]=1 or checkbox[2]=1 or checkbox[3]=1";
你的checkbox2[]传递过来的是字段名?$peerquery = "SELECT * FROM peerprosg where ".join("=1 or ",$checkbox2)."=1";
然后~~SELECT * FROM [xxx] WHERE id in (".$id.")