How to classify in the good categories?

[eluser]Amalgame[/eluser]
Hi gRoberts,

That's right, I want to display entries in each category that are bound by the table bc_ids!

Currently with only one request I get my display has three categories and my entries but when I use the group_by for "Frontend" it shows me an input on two ...

Code:

public function view()
{
  $this->db->where('t_id', $this->uri->segment(3));
  $query = $this->db->get('ids');

  if ( $query->num_rows() >= 1 )
  {
   $this->db->from('categories c');
   $this->db->join('ids i', 'c.c_id = i.c_id', 'inner');
   $this->db->join('hosts h', 'h.h_id = i.h_id', 'inner');
   $this->db->where('i.t_id', $this->uri->segment(3));
   $this->db->group_by('i.c_id');
   $query = $this->db->get();

   $data = array(
    'values' => $query->result()
   );

   $this->parser->parse('roster_view', $data);
  }
  else
  {
   redirect('roster');
  }
}

I do not understand the purpose of your select?

Thank you for your help