Read from one database, write to another database

[Highlord]

Hi,

I have 2 databases with both a table named user in it.

first database name is: main
Table user:

code
firstname
lastname

second database name is: traject
table user
id (autoincr)
code
lastname


Now I want to read from the first database table all the codes and lastnames and write them to the second database using a PHP-script.
I can read all the data, but I cant work in 2 different databases at the same time I think.

I make a connection with main, read the data out of user, but then I dont know how to insert those records in the second database.

Anyone any idea how to do this?

[fenway]

Once you pull all the data back, you now "have it" -- simply make another connection, and put it back.