I want to separate values in mysql using join in codeigniter

Question

My mysql table look like

ranks are rank1,rank2,rank3 on id 1
but i want to show like that 
id 1 -> rank1
id 1 -> rank2
id 1 -> rank 3

i want to split single row into multiple rows please guide me — Raja Tayyab, Sep 03 '19 at 11:02
already some people solved this type of problems, check this url https://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows — jvk, Sep 03 '19 at 11:18

score 0 · Answer 1 · answered Sep 03 '19 at 13:38

0

My sql Query

 $this->db->select('rank')->from('rank_restriction');
            $data = $this->db->get();
            $query = $data->result_array();

              foreach ($query as $result) {
            if (!empty($result['rank'])) {
                $result['rank'] = explode('||', $result['rank']);
            }
return $query
        }

answered Sep 03 '19 at 13:38

Raja Tayyab

29
1
5

no it return in same row but i want to split row in multiple rows – Raja Tayyab Sep 03 '19 at 14:38

I want to separate values in mysql using join in codeigniter

1 Answers1