Need help making a script that moves data into acrhive table

Posted on 16th Feb 2014 by admin

Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a buisness and they are posted out into a table after they are submitted in a form.

The page where you can see all your sales lead have an option to delete sales lead, but i need to write a script that can archive the specific sales lead into an other mysql table.
In my database i've created an excactly identical table to the original to store the archived rows.
I need it to be a link behind each row that says archive and moves the data into the archive table.

How can i do this?

Other forums