Jump to content

Archived

This topic is now archived and is closed to further replies.

Highlord

Read from one database, write to another database

Recommended Posts

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?

Share this post


Link to post
Share on other sites
Once you pull all the data back, you now "have it" -- simply make another connection, and put it back.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.