transfering entries

[itworks]

i have a temporary table that stores entries to users request and the user has the hability to se how many he has added.

at some point, when he has had enough he has a button that he can click to store those entries in a definitive table.

how do i make it possible to transfer those entries (insert them into the definitive table and delete them from the temporary table)?

this is the last step of a shopping cart i'm developing and the one that got me really stuck.

thanks in advance.

[Elena_Mitovska]

These 2 queris may help to transfer data from one table to another:

Insert into my_table(column_1, ..., column_n) Select column_1, ....column_n from temp_table where id_user=$id_user

Delete from temp_table where user=$id_user

[itworks]

i didn't knew that syntax was possible, yet another question has come into my mind that i forgot to ask.

is there a possibility to group the entries in the temp_table in just one entry in the definitive_table? or some way to identify that they correspond to the same order?

my temp_table looks like this

email = char(254)
cod = char(254)
qty = char(254)
type = char(254)
model = char(254)
price = char(254)
id = int(11) PRIMARY KEY

my definitive_table looks like this

email = char(254)
cod = char(254)
status = char(125)
address = char(125)
zip_code = char(254)
city = char(254)
date = char(254)
id = int(11) PRIMARY KEY

thanks in advance