Having trouble with $this->db->insert_id()

[eluser]Chad Crowell[/eluser]
I found some info on the web that the odbc_insert_id command from PHP doesn't work too well, so I decided not to fight it and went with this, which works fine as this is a low transaction site.

Code:

function add() {
        
        //grab the post
        $kitname = $this->input->post('kitname');
        
        if ($kitname != false) {
            
            //put the kit into the db
            $data = array(
                    'kitname'     => $kitname,
                    'active'    => 0
                    );
                    
            //perform the insert
            $result = $this->db->insert('kits', $data);
            
            if ($result) { //insert was successful
                
                //we need to get that kit id now
                $this->db->select('id')->from('kits')->order_by('id','desc')->limit('1');
                $query = $this->db->get();
                
                if ($query->num_rows() > 0) {
                    
                    $row = $query->row();
                    
                    $kit_id = $row->id;
                    
                    //send the user to the edit form
                    redirect('kits/edit/'.$kit_id, 'refresh');    
                    
                }
                
            }
            
        }
        
    }