title: codeigniter active record select query not working
body: <p>i would like to get <code>industry</code> of a <code>candidate</code> from the <code>database</code> for that i have written the following:</p>
  
  <pre><code> $candidateID = '1,2,3,4,5,6,7,8,9';
  
   function get_industry($candidateID) {
      $this-&gt;db-&gt;select('current_industry');
      $this-&gt;db-&gt;group_by('current_industry');
      $this-&gt;db-&gt;from('candidate_details');
  
      $this-&gt;db-&gt;where_in('user_id', $candidateID);
  
      $query = $this-&gt;db-&gt;get();
      print_r($this-&gt;db-&gt;last_query());
      if ($query-&gt;num_rows() &gt; 0) {
          foreach ($query-&gt;result() as $row) {
              $data[] = $row;
          }
          return $data;
      }
      return false;
  }
  </code></pre>
  
  <p>but when i execute this query it only returns me the industry of the <code>first</code> candidate out of <code>9</code></p>
  
  <p>i dont know what i am missing here..any help or suggestion would be a great help..thanks in advance..</p>