A connection to 2 databases
I'm wanting to spread content across two or more database, as I anticipate the data will exceed the 1Gb database limit imposed by the provider - but I can have unlimited database.
I've noted that to do an inner join, you do database1.tablename.fieldname, database2.tablename.fieldname etc - but the MySQL_i connection referenced is to one database. How can I do the connection so it covers two database?
$hostname_connEGM_i = "localhost";
$database_connEGM_i = "egmtest";
$username_connEGM_i = "";
$password_connEGM_i = "";
$connEGM_i = new mysqli($hostname_connEGM_i, $username_connEGM_i, $password_connEGM_i, $database_connEGM_i);