title: select from multiple columns: codeIgniter
body: <p>I want to select multiple columns in a table using codeIgniter active records. Selecting using </p>
  
  <pre><code>    $this-&gt;db-&gt;select('*');
      $this-&gt;db-&gt;from($this-&gt;table_name);
  </code></pre>
  
  <p>but selecting a number of columns e.g. </p>
  
  <pre><code>   $this-&gt;db-&gt;select('username','email','last_login','created','modified','group_id');
      $this-&gt;db-&gt;from($this-&gt;table_name);
  </code></pre>
  
  <p>does not work.It only returns an array with the values from the first column. How should I do this?</p>
  
  <p>according to the CodeIgniter user guide they gave the following example. so I thought it should work in my case.</p>
  
  <pre><code>$this-&gt;db-&gt;select('title, content, date');
  
  $query = $this-&gt;db-&gt;get('mytable');
  
  // Produces: SELECT title, content, date FROM mytable
  </code></pre>