如何在mysql php中使用IN OPERATOR删除所有行

Question

i am having problem in understanding the behaviour of this programme below is simple code to delete the email address using IN operator

$emails = $_POST['ids'];
    $sql = "DELETE FROM newsletter where email ";
    $condition = sprintf('IN ("%s")',implode(' "," ',$_POST['ids']));
    $sql = $sql.$condition;
    include '../includes/db.php';
    $r = mysql_query($sql);

    echo $sql;

it only deletes one email id and returns true . how can i make it run in a way it deletes all the emails .

below is the query constructed using the above code.

DELETE FROM newsletter where email IN ("[e-mail] "," [e-mail] "," [e-mail] "," [e-mail] "," [e-mail]")

is it wrong way of deleteing ?

Answer 1

Instead of:

$condition = sprintf('IN ("%s")',implode(' "," ',$_POST['ids']));

do:

$condition = sprintf('IN ("%s")',implode('", "',$_POST['ids']));

IN operator matches contents of the field with the values exactly. Spaces at the beginnings and ends of values might have cause your problems.