Thanks guys, I think I'm OK with what I want to do. Just to clarify, not expencting any response, my main database holds all my service's transaction records. The other databases are ones that my customers have as workflow managers. The updates would be specific to each customer and not 'global'. Thanks for the tips. George > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] > Sent: 13 December 2003 8:54 am > To: ''George Pitcher ' '; ''php-windows@lists.php.net ' ' > Subject: RE: querying more than one db from a php page? > > > Another thought - came to me just after I posted below: > > If you decides to execute the same update at several > databases from a php page, make sure that you actually > did update all databases! Because you might like to > rollback the update on all database if you fail with > one for them, especially if you was not able to update & osemite]
