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 the main site. However it is up to the design process to decide how much inconsistency that might be allowed betwen the databases. -----Original Message----- From: Svensson, B.A.T. (HKG) To: 'George Pitcher '; 'php-windows@lists.php.net ' Sent: 2003-12-13 09:47 Subject: RE: querying more than one db from a php page? You might run into the classical update problem if you allows update in different databases and then wants to syncronize the databases with each other. To prevent update anomalies like this you need a lock mechanism between the databases. Check your RDBMD documentation on this. However if you only do updates on the main site and then propagate the update to the "sub" sites, you might like the RDBMS to handle this by it self, if so you should check if replication between databases can solve your problem. If you do updates from the main site only and propagate them to the sub sites then I do think that you should not run into any particular problem since the aporach is straight forward. -----Original Message----- From: George Pitcher To: php-windows@lists.php.net Sent: 2003-12-12 17:19 Subject: querying more than one db from a php page? Hi, I am developing my main site to run on php/mysql (currently lasso/filemaker). I am also developing some individual sites to be hosted on the same server as my main one and I'd like to be able to update those smaller site databases when activity happens on the main site. I'm still a couple of months away from tackling that part but can anyone predict trouble ahead, and if so, any remedies? MTIA George in Oxford/Edinburgh -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
