Access 2nd MySQL db in PHP without mysql_select_db()

Question

If I select a db db1 with mysql_select_db() is it possible to access another db db2 in a query? I am looking for something like SELECT * FROMdb2.sometableWHERE 1

Answer 1

I think yes - have you tried it? and do you have access privileges to the 2nd db?

Answer 2

That syntax should work perfectly fine. If you want to access a table from another database the syntax is:

SELECT * FROM DatabaseName.TableName WHERE ....

However, this only works if both databases are on the same instance of MySQL.

Answer 3

its possible just reference the db name in your query like select * from db.table