limit in mysql

[eluser]xwero[/eluser]
[quote author="wish_bear" date="1204897606"]I think I might go with xwero's answer.. may be your data in the table are insufficient to show 20 records.. [/quote]
I think you got the wrong idea the get method puts the limit before the offset which could confuse some people because in the (my)sql statement it's the other way around.

Code:

$this->db->get('table',10,20);

Returns

SELECT * FROM table LIMIT 20,10

So you need to have over 20 records. If you have 21 records you get one record as result.