Help with join tables

[eluser]danmontgomery[/eluser]

Code:

$this->db->join(‘ron’, ‘ron_data.level1 = ron.id ‘);

Because you're only joining on level1...

Code:

$this->db->select('ron_data.id, l1.label AS level1, l2.label AS level2, l3.label AS level3, l4.label AS level4', FALSE)
    ->join('ron AS l1', 'l1.id = ron_data.level1')
    ->join('ron AS l2', 'l2.id = ron_data.level2')
    ->join('ron AS l3', 'l3.id = ron_data.level3')
    ->join('ron AS l4', 'l4.id = ron_data.level4')
    ->where('ron_data.level1', $segm)
    ->get('ron_data');