title: How should I show specific data not all data from database?
body: <p>I had met a basic problem that i want to show specific ‘account’ not all account data from database.</p>
  
  <p>Just like the pic <strong><a href="http://ellislab.com/?ACT=33&amp;fid=49&amp;aid=16429_9B4SZ7MK8EhZwpGybleE&amp;board_id=1" rel="nofollow">Here</a></strong>, If the user’s account is <em>'chiquitta'</em></p>
  
  <p>When user need to edit her account setting</p>
  
  <p>It should only show her account information not all of the account information from database.</p>
  
  <p>I had try to solve this problem but it still show all account ~
  Did I miss something?</p>
  
  <p>[my controller]</p>
  
  <pre><code>function index($id = false)
   {
    $data['page_title'] = lang('admins');
    $data['admins']  = $this-&gt;auth-&gt;get_admin_specific($id);
    $this-&gt;load-&gt;view($this-&gt;config-&gt;item('admin_folder').'/admins', $data);
   } 
  </code></pre>
  
  <p>[my model]</p>
  
  <pre><code>function get_admin_specific($id)
   {
    $this-&gt;CI-&gt;db-&gt;select('*');
  
    if ($id)
    {
    $this-&gt;CI-&gt;db-&gt;where('id', $id);
    }
  
    $result = $this-&gt;CI-&gt;db-&gt;get('admin');
    $result = $result-&gt;result();
  
    return $result;
   } 
  </code></pre>
  
  <p>[my view]</p>
  
  <pre><code>&lt;?php foreach ($admins as $admin):?&gt;
  &lt;?php echo $admin-&gt;account; ?&gt;
  &lt;?php endforeach; ?&gt; 
  </code></pre>