title: Move data from one MySQL table to another
body: <p>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)</p>
  
  <p>Here is what i have tried (found from Google):</p>
  
  <pre><code> $result=mysql_query("Insert Into archived (select * from registrations WHERE id=$id") ;
   $row = mysql_fetch_array($result);
  </code></pre>
  
  <p>This doesn't move it... can anyone help?</p>