I am putting data into a temporary table ("prefs_tmp") which is an *empty* copy of the "prefs" table. After the user completes the proper registration I want to simply move the contents of the temporary table to the permanent one and drop the temporary one.
Is there a simple way to do this without having to parse the temporary table and INSERT into the perm one? I have looked in my PHP books (3 of em), my mySQL book, and usenet, and .....
Thanks,
Zach
Is there a simple way to do this without having to parse the temporary table and INSERT into the perm one? I have looked in my PHP books (3 of em), my mySQL book, and usenet, and .....
Thanks,
Zach