[RESOLVED] move from database 1 to database 2

[kender]

i have information that i would like to move from 1 database to another

it is several columns

basically, ALL information with username XXX move from data_one to data_two, add some more info that is supplied on the page already then delete the whole row from data_one

how would i do it?

[bastien]

break it down into small steps...

open the connection
read the record in
get the additional data from the form
open the 2nd connection
write the record
query the record to ensure it inserted correctly with all data
close second record
delete the first record
close the connection

[kender]

taking it one step further

thanks for the idea!!

im doing it one step at a time, verifying data to make sure it all comes across, then doing the next step

btw: cat is red meat