Database Config Load Question

[eluser]Craig A Rodway[/eluser]
Ah, okay. A mixture of the two should work then:

Code:

// Get the DB info we need from first DB as set in config/database.php
$sql = 'SELECT * FROM table LIMIT 1';
$query = $this->db->query($sql);
$row = $query->row();

// Create new database configuration array using info from previous SQL query
$config['hostname'] = $row->hostname;
$config['username'] = $row->username;
$config['password'] = $row->password;
$config['database'] = $row->database;
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = FALSE;
$config['db_debug'] = TRUE;
$config['active_r'] = TRUE;

// Connect to second database with values from above and assign to new variable
$DB2 = $this->load->database($config, TRUE);