title: limit clause in codeingiter does't work
body: <p>my limit in below code doesn't work. query fetch all records : </p>
  
  <pre><code>    $this-&gt;db-&gt;select('users.id as user_id');
      $this-&gt;db-&gt;select('users.username');
      $this-&gt;db-&gt;select('traction_details.title');
      $this-&gt;db-&gt;select('traction_details.tr_id');
      $this-&gt;db-&gt;select('tractions.buy_id');
      $this-&gt;db-&gt;select('tractions.coupon_code');
      $this-&gt;db-&gt;select('tractions.coupon_property_id');
      $this-&gt;db-&gt;select('tractions.expired');
  
  
      $this-&gt;db-&gt;from('tractions');
  
  
      $this-&gt;db-&gt;join('traction_details' , 'traction_details.tr_id = tractions.id');
      $this-&gt;db-&gt;join('users' , 'tractions.user_id = users.id');
      $this-&gt;db-&gt;join('coupon_cats' , 'tractions.coupon_parent = coupon_cats.coupon_id');
      $this-&gt;db-&gt;where('coupon_cats.cat_id =' , '13');
      $this-&gt;db-&gt;where('tractions.succ =' , '1');
  
      $this-&gt;db-&gt;group_by('tractions.buy_id');
      $this-&gt;db-&gt;order_by('traction_details.tr_id', 'desc');
  
      $this-&gt;db-&gt;limit(0, 10);
  
  
      $result = $this-&gt;db-&gt;get()-&gt;result();
  
      return $result;
  </code></pre>