Need help making a script that moves data into acrhive table

Posted on 16th Feb 2014 07:03 pm 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?

Your Answer:

Login to answer

Other forums

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid

IP Based Cron Jobs
I run cronjobs on my website. After one of my visitors got curious and tinkered around he realized h

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

HeaderSelectedCssClass not working
I have an accordian where I have a drop down list in the first pane and a grid in the second pane.

PHP IMAGE UPLOAD SCRIPT
Hi for the last week i have been looking for scripts that will upload a photo to a certain folder wh