$query ="SELECT Bus_O,Bus_N,C_Loc,Acreage FROM pesticide_sensitive_crop where ctyid=$v ";
改成
$query ="SELECT Bus_O,Bus_N,C_Loc,Acreage FROM pesticide_sensitive_crop where ctyid in (3,5,8....)";
改成这样的形式,自己整理一下!
改成
$query ="SELECT Bus_O,Bus_N,C_Loc,Acreage FROM pesticide_sensitive_crop where ctyid in (3,5,8....)";
改成这样的形式,自己整理一下!
你先循环把$v以英文逗号组成字符串,然后放到SQL的括号里,试一下。
$county=$_GET[county];
foreach($county as $v)
echo $v;
$query ="SELECT Bus_O,Bus_N,C_Loc,Acreage FROM pesticide_sensitive_crop where ctyid=$v ";
$result = mysql_query($query);
if (!$result) {
die("Could not query: ".mysql_error());
}
可以改成
$country = $_GET['country'];
$query = "SELECT Bus_O,Bus_N,C_Loc,Acreage FROM pesticide_sensitive_crop where ctyid in (".implode(",", $country).")";