url segment

[eluser]georgerobbo[/eluser]
I'm trying to query my database based on the second segment in my url, however I'm struggling with the controller side.

My Model, named Post is as follows.

Code:

<?php

class Post extends Model {

    function Post()
    {
        parent::Model();
    }
    
    function get_random_single()
    {
        $this->db->select('*');
        $this->db->orderby('ID', 'random');
        $this->db->limit(1);
        
        $query = $this->db->get('post');
        return $query->result_array();
    }
    
    function get_posts_by_category()
    {
        $category = $this->uri->segment(2);
        
        $this->db->select('*');
        $this->db->where('category', $category);
        
        $query = $this->db->get('post');
        return $query->result_array();
    }
    
}

An my controller category

Code:

<?php

class Category extends Controller {

    function Category()
    {
        parent::Controller();    
    }
    
    function index()
    {
        $data['title'] = "Category";
        
        $data['item'] = $this->Post->get_posts_by_category();
        
        $this->load->view('meta', $data);
        $this->load->view('header', $data);
    }
}