Help session grab user_id from database

[eluser]Samus[/eluser]
I made some mistakes as Chronix pointed out.

Code:

Login Check:

// Logged In
function check()
{
  
    
  $this->form_validation->set_rules('username', 'required|max_length[15]');
  $this->form_validation->set_rules('password', 'required|sha1');
    
  if ($this->form_validation->run() == FALSE) {
  
   $data['title'] = "Customer Login";
   $this->load->view('user/logon', $data);
  }
  else {

// Check user and password
  $query = $this->user_model->checkUser($this->input->post('username'), sha1($this->input->post('password')));
   if($query['true']) {
    
     $result = $query['row'];
    
         $session_data = array(
           'username'     => $result['username'],
           'is_user'      => true,
           'is_logged_in' => true,
           'last_login'   => time(),
           'customer_id'  => $result['id'],
           'acc_number'   => $result['acc_number'],
           'name'         => $result['name']
                );
  
     $this->session->set_userdata($session_data);
     redirect('user/myaccount');
      }
   }
   else {
    // username or password incorrect, should probably create a callback instead
   }
  }
}

Code:

function checkUser($username, $password)
{

  $query = $this->db->get_where('users', array('username' => $username, 'password' => $password));

  if($query->num_rows() == 1)
  {
    $data['true'] = TRUE;
    $data['result'] = $query->row_array();
  }
  else {
    $data['true'] = FALSE;
  }
return $data;
}