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

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

How to change www in url with a specified name
Hi
I'm trying to change the url http://www.sitename.com/apparels to something like below
http:

RadioButtonList item spacing
I have a RadioButtonList and I can't put any spacing between the items. They are arranged verticall

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

Preg_match unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec