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
