title: Help with search query in Codeigniter
body: <p>Im still fairly new to codeigniter and am wondering if someone can help me with this please?</p>
  
  <p>Im just trying to do a very basic search query in Codeigniter, but for some reason, the results are ignoring my "status = published" request...</p>
  
  <p>The code is:</p>
  
  <pre><code>$this-&gt;db-&gt;like('title', $term);
  $this-&gt;db-&gt;or_like('tags', $term);
  $data['results'] = $this-&gt;db-&gt;get_where('resources', array('status' =&gt; 'published'));
  </code></pre>
  
  <p>And this dosent work either:</p>
  
  <pre><code>$this-&gt;db-&gt;like('title', $term);
  $this-&gt;db-&gt;or_like('tags', $term);
  $this-&gt;db-&gt;where('status', 'published');
  $data['results'] = $this-&gt;db-&gt;get('resources');
  </code></pre>
  
  <p>Im sure its something basic? Help please?</p>