[eluser]gtech[/eluser]
are you trying to select the data? in which case you can do a join
Code:
//untested buy you get the idea
$this->db->select('*');
$this->db->from('ci_news_to_categories');
$this->db->join('ci_news','ci_news_to_categories.category_id = ci_news.id');
$this->db->where('subject','I love cheese');
$res = $this->db->get();
and then you can loop through the results to find all the category ids. Or you could do then join in a different way.
or are you asking how to insert the data?