knowram Posted November 1, 2007 Share Posted November 1, 2007 is it possible to select multiple databases from the same server? Thanks for the help. Link to comment https://forums.phpfreaks.com/topic/75662-mssql_select_db-multiple-dbs/ Share on other sites More sharing options...
Barand Posted November 1, 2007 Share Posted November 1, 2007 Yes. You can even join them in a single query. Specify table names as dbname.tablename. mysql_connect ($server, $user, $pwd); $res = "SELECT a.col1, b.col2 FROM db1.table1 as a JOIN db2.table2 as b ON a.col2 = b.col2 Link to comment https://forums.phpfreaks.com/topic/75662-mssql_select_db-multiple-dbs/#findComment-382888 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.