Help session grab user_id from database

[eluser]the_unforgiven[/eluser]
Right here's my login page, check login, model and controller:

Code:

Login Form:

<?php echo form_open('user/check');?>
<table>
  <tr><td>Username:</td><td>&lt;?php echo form_input('username'); ?&gt;&lt;?php echo form_error('username'); ?&gt;</td></tr>
  <tr><td>Password:</td><td>&lt;?php echo form_password('password'); ?&gt;&lt;?php echo form_error('password'); ?&gt;</td></tr>
  <tr><td>&lt;input type="submit" name="submit" value="Login" class="buttonx buttonx-add" /&gt;&lt;/td></tr>
</table>
&lt;?php echo form_close();?&gt;

Code:

Login Check:

// Logged In
function check()
{
  // Check user and password
  $query = $this->user_model->checkUser();
    
  $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 {
   if($query) {
    
     $result = $this->user_model->getCustomer();
    
     foreach($result as $res) {
         $data = array(
           'username'    => $this->input->post('username'),
           'is_user'     => true,
           'is_logged_in'=> true,
           'last_login'  => time(),
           'customer_id' => $res['id'],
           'acc_number'  => $res['acc_number'],
       'name'        => $res['name']
                );
  
     $this->session->set_userdata($data);
     redirect('user/myaccount');
      }
   }
  }
}

Once they are loged in it should keep the session of how it is then move them to a my account page

Code:

My Account:

<div id="tab1">
     &lt;?php if ($this->session->userdata('is_logged_in') && $this->session->userdata('is_user') == TRUE) { ?&gt;
    Welcome back,&nbsp;&lt;?php echo $cust_name; ?&gt;
  &lt;?php } ?&gt;
   </div>

<div id="tab2">
&lt;?php // echo'<code>'; print_r($this->session->userdata); echo'</code>'; echo '<br /><br /><br />'; ?&gt;
Your unique account number: &lt;?php echo $cust_acc; ?&gt;<br /><br />
Update your details:<br /><br />
&lt;form method="post" action="&lt;?php echo base_url(); ?&gt;&lt;?php echo $this-&gt;uri-&gt;uri_string(); ?&gt;" name="update"&gt;
  <table>
   <tr><td>Name:</td><td>&lt;input type="text" name="name" value="&lt;?php echo $customer['name']; ?&gt;" /&gt;&lt;/td></tr>
   <tr><td>Business Name:</td><td>&lt;input type="text" name="businessname" value="&lt;?php echo $customer['businessname']; ?&gt;" /&gt;&lt;/td></tr>
   <tr><td>Address:</td><td>&lt;textarea name="address"&gt;&lt;?php echo $customer['address']; ?&gt;&lt;/textarea&gt;&lt;/td></tr>
   <tr><td>Email:</td><td>&lt;input type="text" name="email" value="&lt;?php echo $customer['email'];?&gt;" /&gt;&lt;/td></tr>
   <tr><td>Phone:</td><td>&lt;input type="text" name="phone" value="&lt;?php echo $customer['tel'];?&gt;" /&gt;&lt;/td></tr>
   <tr><td>Username:</td><td>&lt;input type="text" name="username" value="&lt;?php echo $customer['username'];?&gt;" /&gt;&lt;/td></tr>
   <tr><td>Password:</td><td>&lt;input type="password" name="password" value="" /&gt;&lt;/td><td>Password Again:</td><td>&lt;input type="conf_password" name="conf_password" value="" /&gt;&lt;/td><td><small>Only enter a password if you are changing it, otherwise it will still the same</small></td></tr>
   <tr><td>Website:</td><td>&lt;input type="text" name="website" value="&lt;?php echo $customer['website']; ?&gt;" /&gt;&lt;/td></tr>
   <tr><td>&nbsp;</td><td>&lt;input type="submit" name="submit" value="Update" /&gt;&lt;/td></tr>
  </table>
&lt;/form&gt;
</div>

Code:

Model:

// Check user againest the login details
function checkUser()
{
  $this->db->where('username', $this->input->post('username'));
  $this->db->where('password', sha1($this->input->post('password')));
  
  $query = $this->db->get('users');

  if($query->num_rows() == 1)
  {
   return TRUE;
  }
  else {
   if (empty($username) || empty($password))
    {
     $this->session->set_flashdata('message','<strong>Ooops!</strong><br />Username and/or Password cannot be empty, please try again.');
     redirect('user/', 'refresh');
    }
  }
}

// Get Customer
function getCustomer()
  {
    $data = array();
    
    $username = $this->input->post('username');
    
    $this->db->limit(1);
    $this->db->where('id',$this->session->userdata('customer_id'));
    $this->db->where('username' ,$username);
    $gC = $this->db->get('users');
    if ($gC->num_rows() > 0){
         $data = $gC->row_array();
    }
      $gC->free_result();    
      return $data;
}