[eluser]Unknown[/eluser]
Hello !,
I need help with query. I have two tables:
table: ron
-----------------
|id | label |
|-----------------|
| 1 | one |
|-----------------|
| 2 | two |
|-----------------|
| 3 | three |
|-----------------|
| 4 | four |
-----------------
table: ron_data
----------------------------------------
| id | level1 | level2 | level3 | level4 |
|----------------------------------------|
| 1 | id1 | id2 | id3 | id4 |
|----------------------------------------|
| 2 | id3 | id4 | id1 | id2 |
|----------------------------------------|
| 3 | id1 | id4 | id3 | id2 |
|----------------------------------------|
| 4 | id4 | id2 | id3 | id1 |
----------------------------------------
I want to join these two tables (every value from ron_data in field level1, level2, level3, level4 is id from table ron.
i want result:
----------------------------------------
| id | level1 | level2 | level3 | level4 |
|----------------------------------------|
| 1 | one | two | three | four |
----------------------------------------
I am using statement join:
$this->db->where('ron_data.level1', $segm);
if($segm1<>''){$this->db->where('ron_data.level2', $segm1);}
if($segm2<>''){$this->db->where('ron_data.level3', $segm2);}
if($segm3<>''){$this->db->where('ron_data.level4', $segm3);}
$this->db->select('ron_data.*, ron.id AS label_id, ron.label AS label');
$this->db->join('ron', 'ron_data.level1 = ron.id ');
$query=$this->db->get('ron_data');
With this code i get only first column level1 joined.
Please help