Re: Query from multiple databases

[Davor Ergotic]

Tx all for reply but I found a solution.
After reading about 50 different articles on the web I found the solution.

This is the code:

$sql = "SELECT p1.column1, p1.column2, p2.column1, p3.column1, p3.column2 FROM (database1.table1 p1 LEFT OUTER JOIN $database2.table1 p2 ON p1.id = p2.id) LEFT OUTER JOIN database1.table2 p3 on p1.id = p3.id WHERE p1.column3 = 'something' ";

And the thing is that you must connect with the user which has privileges to all databases you want to use.
So I used:

mysql_connect('localhost', 'username', 'password');

I didn't select database!! Just connected to the MySQL server!

Anyway, thx to all!!!