title: Distinct use in codeigniter
body: <p>I have the following query in codeigniter
  The idea is to only get distinct rows - the column I want to use this on is called club_id - any ideas how to do this in codeigniter so only one offer shows per club_id?</p>
  
  <pre><code>$this-&gt;db-&gt;distinct();
  $this-&gt;db-&gt;limit($limit);
  $this-&gt;db-&gt;where("UNIX_TIMESTAMP(`end_date`) &gt; ".time());
  $q = $this-&gt;db-&gt;get('offers');
  </code></pre>