How to execute my SQL query in CodeIgniter
$sql="Select * from my_table where 1"; $query = $this->db->query($SQL); return $query->result_array();
If the databases share server, have a login that has priveleges to both of the databases, and simply have a query run similiar to:
$query = $this->db->query("SELECT t1.*, t2.idFROM `database1`.`table1` AS t1, `database2`.`table2` AS t2");
Otherwise I think you might have to run the 2 queries separately and fix the logic afterwards.
I can see what @Þaw mentioned :
$ENROLLEES = $this->load->database('ENROLLEES', TRUE);$ACCOUNTS = $this->load->database('ACCOUNTS', TRUE);
CodeIgniter supports multiple databases. You need to keep both database reference in separate variable as you did above. So far you are right/correct.
Next you need to use them as below:
$ENROLLEES->query();$ENROLLEES->result();
and
$ACCOUNTS->query();$ACCOUNTS->result();
Instead of using
$this->db->query();$this->db->result();
See this for reference:http://ellislab.com/codeigniter/user-guide/database/connecting.html