Tuesday, 26 December 2017

Join query in codeigniter

Join query in codeigniter 


ContentMiddleAd



Sol 1: 

U can modify code like
$this->db->join('credentials', 'tblanswers.answerid = credentials.cid', 'outer'); 
$query 

ContentMiddleAd

= $this->db->get('tblanswers'); return $query->result();
Sol 2: 

Try with this:
$this->db->join('credentials', 'tblanswers.answerid = credentials.cid');
Or
$this->db->join('credentials', 'tblanswers.answerid = credentials.cid', 'inner');

ContentMiddleAd

And print the result to see if is what you want

No comments:

Post a Comment