Copy Table Contents.

[SureFire]

On my website people can create tutorials to teach people video editing.

They create the tutorial in a temporary table, then once it is complete, they can post it to the site, via a table that the site reads.

The temporary table and the final table are structured exactly the same, how can I copy all the contents from the tempory table into the new table?

[barand]

$query = "INSERT INTO table (fieldname1, fieldname2, ..... , fieldnameN)
SELECT (fieldname1, fieldname2, ..... , fieldnameN)
FROM temptable" ;

If you have an auto_increment field, don't include it in the fieldname lists

hth

[SureFire]

well, thats a little more work than I thought it would be, but its less work than I'm doing now, thanks for the help and the autoincrement advice!

Rocky

I'll click on "tread resolved" but it never works for me:-(