Acrive Record: Getting the row total then setting limit clause

[eluser]EEssam[/eluser]
Hi,

My search model looks like the following:

Code:

function get()
    {
        if ($this->brandid)
        {
            $this->db->where('brandid', $this->brandid);
        }

        $this->db->select('*');

        $this->db->from('product');

        $this->row_count = $this->db->count_all_results();

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

        $query = $this->db->get();

        return $query;
    }

But it's not working. I need to set the limit clause because my search results are paginated.

Please help. Thanks.