move row from one table to another

[raffael3d]

I want to make that the admin can move a row from a table to anther table.
I thought I could make it using a "select", but I don't know exactly what I have to do, so that I can add it to the other table and delete it at the same time in the old table.
thanks for any help.

[jburfield]

What database are you using? I'll assume MySQL, but this will work on most as well.

Just do something like this:

insert into table.B SELECT * from table.A where id=$id;

And then:
delete from table.A where id=$id limit 1;

That should accomplish what you are trying to do.

-- Jason

[raffael3d]

thanks a lot!
so far I have a little problem with the select.
I'm not sure how I can make that the user can select form a drop down list to choose the other table.
can you help me with this?