[SOLVED] How do you connect to two databases cleanly ?

[eluser]Henrik Pejer[/eluser]
You would, of course, have to save the different connections.

Something like this should work:

Code:

$this->db1=$this->load->database('group_one', TRUE);
$this->db2=$this->load->database('group_two', TRUE);

then you'd use $this->db1->query('select...') or $this->db2->query('select....') whenever you want to use the connection.

I haven't used two databases with CI but I believe that should work.

Good luck!