[eluser]ChrisMiller[/eluser]
Ok basically I am sure I am just skipping over it somewhere but what I want to do is use the ci database library twice in a controller, when the script is loaded it connects to the database in the config file which is easy to do but then I want to connect to a seperate database using a config specified in file... so the result is $this->db-> = the normal database and $this->app_db = the new loaded database....? any ideas? also I cant just put the config values in the database config file as they are loaded from a database depending on what user is accessing the app.
Code:
$config['hostname'] = "localhost";
$config['username'] = "myusername";
$config['password'] = "mypassword";
$config['database'] = "mydatabase";
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = FALSE;
$config['db_debug'] = TRUE;
$config['active_r'] = TRUE;
$this->load->database($config);
How can I get that so it can be loaded via a diffrent class name like I can do with my libraries. ie $this->db2->
