database config file

[eluser]cinewbie81[/eluser]
[quote author="sergitin" date="1192697313"]I give you the option of to change the value of

Code:

$db['default']['database']

the other option is to begin with one connection setting and then you have created the other database
then you can work with another connection variable and not to touch the original one...
OK??[/quote]

Thanks. It's working now .. The code as following:

Code:

<?php

class Setup extends Controller {

    function Setup()
    {    
        parent::Controller();
            $this->load->helper(array('url', 'form'));
    }


    function RunSetup()
    {
           //"default" is a group that point to mysql database
           $DB1 = $this->load->database('default', TRUE);
           $DB1->query('CREATE DATABASE NEWDB');

           $DB2 = $this->load->database('myDB', TRUE);
    }
}

Anyway, I've got another question.. I have

Instead of have to load the database group everytime, how can I use this $DB1 and $DB2 value in other class of my project ?? Hope someone can help. Thanks !