LIMIT

[eluser]Jamie Rumbelow[/eluser]
[quote author="Browser" date="1257114595"]But, i want to select the rows 1 to 10. LIMIT 10,1 in mysql.[/quote]

The code above should do it; if not just pass 1 as the third parameter:

Code:

function novedades() {
    return $this->db->get('noticias', 10, 1);
}