[DataObjects] - Multiple DB Join

From: Date: Thu, 29 Jun 2006 18:22:00 +0000
Subject: [DataObjects] - Multiple DB Join
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-24522@lists.php.net to get a copy of this message
Hi I want to connect to multiple database within DO and do a join on tables within. The documentation states: -- When you have multiple databases you can use the database_* to specify the DSN for each database Example 33-5. using multiple databases - database passwords database_authentication = mysql://user:password@localhost/authentication
database_sales           = mysql://user:password@localhost/sales
-- Now how do I do this if I am using the ini method : ? The below obviously takes the last DB called. $config = parse_ini_file('authentication.ini',TRUE); foreach($config as $class=>$values) {
    $options = &PEAR::getStaticProperty($class,'options');
    $options = $values;
} $config = parse_ini_file('sales.ini',TRUE); foreach($config as $class=>$values) {
    $options = &PEAR::getStaticProperty($class,'options');
    $options = $values;
} A little bit stuck on this, I havent really figured out how to get the best from the Docs available on Pear site. Ian

« previous php.pear.general (#24522) next »