in reply to Delete multiple values from mysql db..
You really should be running CGI scripts in taint mode (-T); it will help you catch common but serious errors like forgetting to quote input from forms.$sql = "DELETE FROM student WHERE student_id IN (". join(",",map {$dbh->quote($_)} $cgi->param('id')). ")"; $sth = $dbh->prepare($sql); $sth->execute() || die $DBI::errstr;
|
|---|