Library construct

[eluser]CI_Newb[/eluser]
I have a library that has my menus for my site.

Example

Code:

function Menus()
    {
        $this->CI =& get_instance();
        $mydb = $this->CI->load->database('default', TRUE);
    }

function resolution_menu()
    {
        $mydb = $this->CI->load->database('default', TRUE);
        
        $data = array(
            '' => ''
            );
    
        $mydb->select('menu_id, resolutions_menu_item');
        $mydb->order_by("resolutions_menu_item", "asc");
        $query = $mydb->get('cb_menu_resolutions');
        foreach($query->result_array() as $row){
        $data[$row['menu_id']]=$row['resolutions_menu_item'];
            }
            return $data;
    }

I don't want to have to repeat

Code:

$mydb = $this->CI->load->database('default', TRUE);

in every function but can't figure out how to move it to the construct.

Help?

[eluser]dudeami0[/eluser]

Code:

class Menus {

    var $mydb;

    function Menus() {
        $this->CI =& get_instance();
        $This->mydb = $this->CI->load->database('default', TRUE);
    }

    function resolution_menu() {
        $data = array(
            '' => ''
            );
    
        $this->mydb->select('menu_id, resolutions_menu_item');
        $this->mydb->order_by("resolutions_menu_item", "asc");
        $query = $this->mydb->get('cb_menu_resolutions');
        foreach ($query->result_array() as $row) {
            $data[$row['menu_id']]=$row['resolutions_menu_item'];
        }
        return $data;
    }
}

[eluser]CI_Newb[/eluser]
wicked stuff, makes sense now.

Thanks