RE: [PHP-DB] Updating 2 Databases from a single form

Realistically, there are three options: 1. run the code twice to connect and pass the data to each server 2. set up a primary server and use a stored procedure to load the other server (providing db supports it) 3. set up replication and make one a master and the other a slave and the the replication do its work, the flip to this is to make each server a master and slave them off the other Bastien> To: php-db@lists.php.net> From: dmoon3@depaul.edu> Date: Thu, 27 Sep 2007 16:42:10 Bastien> -0500> Subject: [PHP-DB] Updating 2 Databases from a single form> > Hello,> > I was Bastien> wondering if there is anyway to first connect to two databases > simeltaneously. (both reside on Bastien> the same server) . After connecting, I have > a single form that I want to use to update data to Bastien> 2 different tables, both > tables are in different databases.> > So far I have recieved at Bastien> least 10 ways of doing this and none of them seem > to work.> I know there is a way, but I Bastien> cant seem to grasp it from the information that > I have acquired so far.> > Important Bastien> Facts> Both databases have the same login credentials,> Both databases are on the same Bastien> server,> > > Any ideas? > > -- > PHP Database Mailing List Bastien> (http://www.php.net/)> To unsubscribe, visit: Bastien> http://www.php.net/unsub.php> _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us