url values

[eluser]theprodigy[/eluser]
just create another column in your database 'items' table and make sure you set it up as string and unique.
when you do your queries, just base your queries off of that column instead of id.

if you name your column 'code', then your model would have something like

Code:

public function get_items($code) {
    $this->db->select('[put your wanted fields here]');
    $this->db->from('[table name goes here]');
    $this->db->where('code',$code);
    return $this->db->get();
}

and your controller would have something like

Code:

public function category($code) {
    $this->load->model('[model name]');

    $data['items'] = $this->[model name]->get_items($code);

    $this->load->vars($data);
    $this->load->view('[view name]');
}