set query offset in active record with join

[eluser]freshface[/eluser]
I need to set an offset, but how?

Code:

$this->db->select('products_products.id, products_products.reference_id, products_products.stock, products_language_content.name ');
        $this->db->from($this->table);
        $this->db->limit($limit);
        $this->db->where($where);
        $this->db->join('products_language_content', 'products_language_content.product_id = products_products.id', 'right');
        $this->db->where(array('products_language_content.language_id' => LANG_ID));
         $q = $this->db->get()->result();
    
        return count($q) == 0 ? array() : $q;

Any ideas

[eluser]Aniket[/eluser]
You can set offset and limit this way

Code:

$this->db->limit($records_per_page,$offset);

$records_per_page refers to the no of records to display
$offest determines the offset.