multiple database connection

[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.

[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.

[eluser]Pedro Luz[/eluser]
you problablly can do that with the

Code:

$this->db->join();

http://ellislab.com/codeigniter/user-gui...ecord.html

search for join() in that page