$str = $_POST['str']; $arr = split (",", $str); foreache($arr as $name) { $sql = "select ID from A where Name=".$name."; //执行取值,若有返回的ID值,则插入B }
if($names=explode(",",$_POST['names'])){ foreach($names as $name){ $result=mysql_query("select id from a where name='$name'"); if(@mysql_num_rows($result)){ $row=mysql_fetch_row($result); mysql_query("insert into a(id) values($row[0])"); } } }
$arr = split (",", $str);
foreache($arr as $name) {
$sql = "select ID from A where Name=".$name.";
//执行取值,若有返回的ID值,则插入B
}
foreach($names as $name){
$result=mysql_query("select id from a where name='$name'");
if(@mysql_num_rows($result)){
$row=mysql_fetch_row($result);
mysql_query("insert into a(id) values($row[0])");
}
}
}