+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: multiple database connection (/showthread.php?tid=38085)
multiple database connection - El Forum - 01-30-2011
[eluser]Unknown[/eluser]
i know it is possible to query 2 databases at the same time in codeigniter but is it possible to query the following string -> "select db1.table1.field1, db2.table2.field2 FROM db1.table1, db2.table2" thank you.
multiple database connection - El Forum - 01-30-2011
[eluser]jakub[/eluser]
Try the following using a standard query:
http://www.dottedidesign.com/node/14
Good reference on how the user did multiple databases (on 1 host obviously).
An interesting example.
multiple database connection - El Forum - 01-30-2011
[eluser]Pedro Luz[/eluser]
you problablly can do that with the
Code:
$this->db->join();http://ellislab.com/codeigniter/user-guide/database/active_record.html
search for join() in that page