<?php
 
$id=$_GET['id'];
 
$sql="Select * from <tablename> where id=".$id;
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
 
//Call the function to archive the table
//Function definition is given below
archive_record(<tablename>,$row);
 
//Once you archive, delete the record from original table
 
$sql = "Delete from <tablename> where id=".$id;
mysql_query($sql);
 
 
function archive_record($archived_tablename,$row)
{
	$sql = "insert into $archived_tablename values(";
	$i=0;
	while($i<(count($row)-1))
	{
		$sql.="'".$row[$i]."',";
	}
	$i=$i+1;
 
	$sql.="'".$row[$i]."'";
	$sql.=")";
 
	mysql_query($sql);
	return true;
}
?>

$query=mysql_query("SELECT * FROM _table_ WHERE archive='1'");

LOCK TABLES active WRITE, archive WRITE;
INSERT INTO archive
       SELECT * FROM active
                WHERE active_rec_id='$confirmed_id';
DELETE FROM active
       WHERE active_rec_id='$confirmed_id';
UNLOCK TABLES;