[eluser]cinewbie81[/eluser]
Hi all,
I have 2 database connections as following:
Code:
$dbClient = $this->load->database('client', TRUE);
$dbServer = $this->load->database('server', TRUE);
I want to make sure if the system get the correct db connection or not, therefore here is my verification code:
$dbClient->query('show tables');
$dbServer->query('show tables')
both $dbClient and $dbServer will return me 'server' database tables ..
And when i load server database 1st then only client as following:
Code:
$dbServer = $this->load->database('server', TRUE);
$dbClient = $this->load->database('client', TRUE);
Now both $dbClient and $dbServer will return me 'client' database table ..
It seems to me that the system will get the last database it loaded as the connection. Any idea why ? Hope someone can help, thanks.