DELETE using an array

[shottie]

i have some integers entered into an array $delete. i want to delete the records from a mysql database where the id = the id's in the array. something like this:

$delete = array (1, 3, 4, 6, 22);
$rm_item_sql = "DELETE FROM test WHERE id = \"$delete\"";
mysql_query($rm_item_sql) or die("Couldn't delete items.");

this doesn't work. what can i do?

[thecookie]

Impolde the array, $delete = implode(",", $delete;

[shottie]

then what?

[shottie]

ok, so i used implode() and it was able to delete the first record. how to i delete all the records from the array?

$sql = "SELECT * FROM test";
$sql_result = mysql_query($sql,$connection) or die ("couldn't execute query");


while ($row = mysql_fetch_array($sql_result)) {
            $id = $row[id];
			$delete[] = $id;
			}

$newdelete = implode(",", $delete);

$rm_item_sql = "DELETE FROM test WHERE id = \"$newdelete\"";
mysql_query($rm_item_sql) or die("Couldn't delete items.");