insert?

[shya]

i want to delete some data by checked the checkbox and at the sametime i want to insert the data into another table(like want to backup the deleted data)..have any idea?

this is the code for 'delete' part:

<?php

include 'conn.php';

$delete_ids = implode(",",$_POST['delete']);

$sql = "DELETE FROM db_user WHERE id IN ($delete_ids)";

mysql_query($sql);

?>

[kburger]

1. Select the data you're about to delete.

2. Insert that data into a different table.

3. Delete your rows.

[kakki]

what about "SELECT INTO ... ", well i'm not so good at db,
but it think, that mySQL supports that kind of statement,too ...