title: Codeigniter Active Record Limit
body: <p>I have the following code that is working but I want use limit to show only 10 results ordered by ID</p>
  
  <pre><code>$this-&gt;db-&gt;select('*');
          $this-&gt;db-&gt;from('quotes');
          $this-&gt;db-&gt;join('quotes_detail', 'quotes_detail.id_rfq = quotes.id_rfq');
          $this-&gt;db-&gt;join('clients', 'clients.id = quotes.id_company');
          $this-&gt;db-&gt;limit(10,1);
  
          $query = $this-&gt;db-&gt;get();
          $result = $query-&gt;result();
          return $result; 
  </code></pre>
  
  <p>with the limit code lines, doesn't show anything, but if I remove the line the query works very well.</p>
  
  <p>can anyone help me with this?, thank you.     </p>