DB #1:
Code: Select all
host: localhost
user: root1
pass: pass1
Db: db1Code: Select all
host: localhost
user: root2
pass: pass2
Db: db2DB #3:
Code: Select all
host: localhost
user: root3
pass: pass3
Db: db3Summary of DBs
DB #1 is use for main login page.
DB #2 has table called products2
Code: Select all
products2
--------
id
sku
name
...
Code: Select all
products3
---------
id
sku
name
....
I want perform query in DB #2's products2 table & DB #3's products3 so that i can display the products with common sku.
Hope my problem is clear.
My Question is:
1> is it possible to make a single query for two database? If yes how?
2> if above is not possible then,
Would it be effective to make separate fetching from two dbs as an arrays.
And manipulating that array for the required results?
Thanks