April 19th, 2000, 09:43 AM
I would like to connect to two different mysql databases on two different machines and run a query using tables from these two different DB's.
Is that possible directly or should I store a query on DB1 first as a temp table in DB2 and then run a query against a table in DB2 and the temp. table?
I use PHP4 and Apache 1.3.12.
I hope someone can help me on the way.
April 19th, 2000, 12:24 PM
You can join tables in different databases on the same machine but not on different machines. You'll need two seperate queries.
April 19th, 2000, 06:02 PM
and how can I do that, I'm pretty new to PHP, MySQL and SQL in particular.
April 20th, 2000, 11:11 AM
Well, that really depends on what you are trying to do. What information in the first database affects what you are trying to do in the second and how, etc.