title: Combining codeigniter active records function with regular sql statement
body: <p>Is it possible to use codeigniter active records functions as an add on to the end of a regular sql statement? Something like this :</p>
  
  <pre><code>$sql = "SELECT * FROM test WHERE id = 'red'";
  $this-&gt;db-&gt;WHERE_IN('code', $array);
  $query = $this-&gt;db-&gt;get($sql);
  return $query-&gt;result();
  </code></pre>
  
  <p>I really need the where_in function so i can apply an array of values, in which the number of values is constantly changing</p>
  
  <p>Why do I want to do it this way instead of just doing it all in active records function? Because when I used just active records functions, I kept getting errors, and I don't want to spend more time smashing my head against the table in frustration.</p>