CodeIgniter Join 2 columns from different tables to another different table

Asked Oct 11 '16 at 06:42

Active Oct 11 '16 at 06:42

Viewed 689 times

I want to select two columns from different tables: dbusers.students.ID and dbusers.parents.ID

Into another table of another database: dbrecords.consultations.SENDER

Which translates into CodeIgniter code as:

$this->dbrecords->select('consultations.*, dbusers.parents.*, dbusers.students.*');

$this->dbrecords->from('consultations');
$this->dbrecords->where('receiver', $id);
$this->dbrecords->order_by('DATE_SENT', 'DESC');
$this->dbrecords->order_by('TIME_SENT', 'DESC');

$this->dbrecords->join('sctporta_dbusers.parents', 'sctporta_dbusers.parents.ID = consultations.SENDER');
$this->dbrecords->join('sctporta_dbusers.students', 'sctporta_dbusers.students.ID = consultations.SENDER');

$query = $this->dbrecords->get();
return $query->result_array();

And I am getting empty results. If I try to only use two tables, it works. But I want to join the two tables into another table.

asked Oct 11 '16 at 06:42

aronccs

u need to add database alias on all location like `$this->dbrecords->from('consultations');` – devpro Oct 11 '16 at 06:55
How to do that in CodeIgniter? – aronccs Oct 11 '16 at 06:59
http://stackoverflow.com/questions/14159130/codeignitor-multiple-database-join – devpro Oct 11 '16 at 07:03
http://stackoverflow.com/questions/14159618/join-query-of-two-databases-in-codeigniter – devpro Oct 11 '16 at 07:04
http://stackoverflow.com/questions/36416794/joining-tables-from-two-databases-using-codeigniter – devpro Oct 11 '16 at 07:04

CodeIgniter Join 2 columns from different tables to another different table

0 Answers0