Moving Information From One Table To Another

RobRocker

Hello Everyone,

I am trying to make a script that will move one row of information to another table within the same database.

I know I can use a:

INSERT INTO $tabletake SELECT * FROM $tablegive WHERE id = $id

But I would also like the user to be able to select which table the information goes into.

I was thinking about a javascript window that the user can select a radio button on which table to insert into, but I do not know how to take the information from the JS window and enter it back into the php code.

What is the best way to do this?

Here is my best illustration on how I am trying to structure it.
Root Folder:
|index (main script)
: |_functions/function (link inserted with a php include)
:__ Javascript window (the window is called from the main page but is coded in the include)
I have the variables grabbed from the php include function and passed to the index that includes the main script.

If this is to confusing let me know, Ill draw it out on a jpg and upload the picture, or if you know a better way to structure that would help. :-)

God Bless,

Savahn

You might try something like this.

$selectedtable = $_POST['tablename']
$sourcetable = $_POST['tablename']
INSERT INTO $selectedtable (SELECT * FROM $sourcetable)

The SELECT statement should be setup so that the information selected is INSERTED into the 2nd table with same column names. I.E. Sourcetable, (SELECT Username, Password FROM Users), DestTable (INSERT INTO InactiveUsers (SELECT Username, Password from Users) - the column Username and Password must exist in the DestTable.

Instead of using Javascript why not put the tables names in a dropdown box(<select><option>) on the same page. When the user selects the desired tables and hits submit the table names will be passed thru the $_POST to the same page or another page declared in the <form> tag.

RobRocker

Hmm... Thanks for the help... Im gonna try it and get back to ya.

NogDog

Would it possibly be simpler (and more in line with typical data normalization) to keep the data in one table, and either add a field to that table or else use a separate relation table to indicate the "take" or "give" status of a given item?

RobRocker

Just wanted to say thanks,
I got it to work properly