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

Inserting into MySQL Newbie
Hi ive got a slight problem where ive made a simple web form where the customer inserts the ammount

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - P

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery
Hi Experts,

I was able to successfully create an Inbound delivery with reference to a PO

Checking BOM Authorization Group
Hai Friends,

I have developed a mulitilevel BOM display report. End users have been assig

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones