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?

No comments posted yet

Your Answer:

Login to answer
259 Like 20 Dislike
Previous forums Next forums
Other forums

Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:

How to submit a form to the same page?
I have a table containing information about books in my library and this table has the following col

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Call db table from any PHP file
Hi,

I want to be able to call a database table that will be setup in another file called init

iMatch stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash