checkbox again

[shya]

hy guys..really stuck with this thing..i want to delete multiple items but at the same time i want the deleted items to be insert into another table..it's like backup the deleted items..well, so far, i've got the delete part..but sadly, still can't work with the insert part..help me please!
here's the code..

[coreyp_1]

Something like this, perhaps?

foreach ($_POST['delete'] as $deleteid) {
  $query = 'SELECT * FROM db_book WHERE id=$deleteid';
  $resource = mysql_query($query);
  if ($result = mysql_fetch_array($resource)) {
    $query = "INSERT INTO 
      new_table_foo (col1, col2, col3) 
      VALUES 
      ('{$result['val1']}', '{$result['val2']}', '{$result['val3']}')";
    mysql_query($query);
    $query = "DELETE FROM db_book WHERE id=$deleteid";
    mysql_query($query);
  }
}

You'll have to fill in the insert query table name, column names, values, and whether or not to use quotes.

[topsub]

nice