How to make a mysql query to select from 2 databases?

Question

PHP

Good day. I need to fetch data from two databases.
Please tell me what I'm doing wrong:

$dbh1 = mysql_connect('host', 'log', 'pass'); 
$dbh2 = mysql_connect('host', 'log', 'pass'); 

mysql_select_db('db_name', $dbh1);
mysql_select_db('db_name2', $dbh2);

$query = "SELECT `db_name1`.`content`.`title`, `db_name2`.`news`.`title` 
FROM `db_name1`.`content` LEFT JOIN `db_name2`.`news`
ON `db_name1`.`content`.`title` = `db_name2`.`news`.`title` ";
$query = mysql_query($query);
var_dump($query);

Null is output.

Answer 1

If the databases are on different servers, then such a trick with the 1st request will not work

Answer 2

SELECT <write here the fields from the two bases that we want to display after the query>
FROM <write the first base (table)
here> INNER JOIN <write the second base (table) here>
ON <write the condition here, if the fields match, the fields should be displayed >
--------------------------------
Read Kevin Yank, p. 123 (on p. 126, everything is detailed) .
Good luck.

Answer 3

SELECT t1.*, t2.*
FROM database1.table1 AS t1
INNER JOIN database2.table2 AS t2 ON t2.field1 = t1.field1
You connect to the DBMS and then select the active database (which is not necessary in this case).
Read documentation