Jump to content


Photo

Read from one database, write to another database


  • Please log in to reply
1 reply to this topic

#1 Highlord

Highlord
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 04 September 2006 - 11:23 AM

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?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 September 2006 - 02:57 PM

Once you pull all the data back, you now "have it" -- simply make another connection, and put it back.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users