mysql - 从数据库中删除多个值

Question

我正在使用这个文件从服务器上删除记录

<?php

$dbhandle = mysql_connect("localhost", "admin", "admin") or die(mysql_error()) ; 
$selected =  mysql_select_db("dbname" ,$dbhandle) or die(mysql_error()) ; 


$id=$_POST['id'];

foreach($id as  $value)
{

 $query = mysql_query("DELETE FROM `record` WHERE `id`=$value");
}
 mysql_close($dbhandle);
?>

但我无法从数据库中删除记录。查询正在执行，没有任何错误，但它无法从表中删除记录

Answer 1

$query = mysql_query('DELETE FROM `record` WHERE `id` IN (' . implode(',', array_map('intval', $id)) . ')');