Multiple database + pconnect issues

[eluser]Nanodeath[/eluser]
Hmm, while that would work, I think it makes things a little less...encapsulated? Also possibly more confusing.

My preferred way:

Code:

$src = 'commontable';

$db_source = $this->load->database($database_source, true);
$db_destin = $this->load->database($database_destination, true);
$srcFields = $db_source->list_fields($src);
$destFields = $db_destin->list_fields($src);

Way you suggested:

Code:

$src = 'commontable';

$db = $this->load->database($database_source, true);
$srcFields = $db->list_fields($src);
$db->db_select('someotherdb');
$destFields = $db->list_fields($src);

Though you could modify the db_select you suggested so that it takes a database_group instead of the name of a single database, but then that group could have other connection settings...see what I mean? It's just that if you have $db1 = $thisDb and $db2 = $thatDb, that should work regardless of other settings, without extra php on the developer's side.