limit in mysql

[eluser]Michael Wales[/eluser]

Code:

$query = $this->db->get(’mytable’, 10, 20);

Not sure how you could even deduce that would only show the first 2 queries but I will venture to explain what this will show. The query will be:

Code:

SELECT * FROM `mytable` LIMIT 10, 20

This means, start at record 20, and get the next 10 items.

Code:

$query = $this->db->get(’mytable’,2)

This means, start at record 0 (the first record in the table), and get the next 2 items.