On 2011-09-30, at 8:26 PM, "Ron Piggott" <ron.piggott@xxxxxxxxxxxxxxxxxx> wrote: > > I need my Prepared Statement database connection to be able to connect with two different databases (which use the same username / password). > > They are assigned variables > > $database1 and $database2 > > What I have been using so far is: > > > $dsh = 'mysql:host=localhost;dbname='. $database1; > $dbh = new PDO($dsh, $username, $password); > > > Is there a way to amend this with a second database connection? > > Ron > > > > www.TheVerseOfTheDay.info A simpler option maybe to use the dbname.tablename syntax to donthe query Select db1.somefield, db1.anotherfield... Select db2.somefield, db2.someotherfield Bastien Koert 905-904-0334 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
