Re: [PHP-DB] Querying tables on multiple hosts in a single query

2003-10-15 Thread Lester Caine
Added to this I would have a seperate connection for each of the customer db and the rules db. Currently, I have no idea how to achieve the above query given the new situation - mysql_query only accepts a single connection link. Does anyone know if there is anyway that I can perform the above qu

[PHP-DB] Querying tables on multiple hosts in a single query

2003-10-15 Thread Rory McKinley
All The situation is thus: We are building an application (using a PHP frontend - 4.3.3 ) that processes large amounts of customer data (in some cases GB). During the processing we run queries where we compare the customer data to a number of rules tables (in a number of rules databases), e.g