I am trying to move data from one database (registrations) to another when the user clicks a button named delete. (I want to move the data to a table named archived)
Here is what i have tried (found from Google):
$result=mysql_query("Insert Into archived (select * from registrations WHERE id=$id") ; $row = mysql_fetch_array($result);
This doesn't move it... can anyone help?