multiple table select - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: multiple table select (/showthread.php?tid=64925) |
multiple table select - nimmuk09 - 04-11-2016 Hi, My model : return $this->db->query("select a.msisdn , a.status , s.scoring_loan , s.scoring_fee , s.status , s.scoring_tenure , s.validity from accounting a, scoring s where a.msisdn = $msisdn and a.msisdn = s.msisdn;")->result(); I would like to change it to something neat like: return $this->db->select('select a.msisdn' , 'a.status , s.scoring_loan' , 's.scoring_fee' , 's.status ', 's.scoring_tenure ', 's.validity')->from('accounting a', 'scoring s')->where('a.msisdn = s.msisdn')->where('msisdn', $msisdn)->results(); But it doesn't work. Is there a way to do multiple select without using join? Thanks RE: multiple table select - Parker1090 - 04-12-2016 $this->db->select() doesn't support multiple values, nor an array. You can however just specify them in one string (also remove the word 'select'). In a similar way, from() accepts a string, but can accept an array. PHP Code: return $this->db->select('a.msisdn, a.status, s.scoring_loan, s.scoring_fee, s.status, s.scoring_tenure, s.validity')->from('accounting a, scoring s')->where('a.msisdn = s.msisdn')->where('msisdn', $msisdn)->results(); Not tested RE: multiple table select - Wouter60 - 04-12-2016 I would prefer the join statement: PHP Code: $this->db |