Switching databases

http://www.codeigniter.com/user_guide/da...-databases

PHP Code:

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

$db1->query('select something from db1');
$result1 = $db1->result();

$db2->query('select something from db2');
$result2 = $db2->result(); 


or, if the connections are the same and just the database is different...

PHP Code:

$this->db->db_select('database1');
$this->db->query('select something from database1');
$result1 = $this->db->result();

$this->db->db_select('database2');
$this->db->query('select something from database2');
$result2 = $this->db->result(); 


good one

Musheer
http://codesok.com