Just remember to close the correct connection whn it is time to :) -----Original Message----- From: Matijn Woudt [mailto:tijnema@xxxxxxxxx] Sent: 19 May 2012 23:42 To: Ron Piggott Cc: php-db@xxxxxxxxxxxxx Subject: Re: Multiple Database Connection Using Prepard Statements On Sat, May 19, 2012 at 8:36 PM, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx> wrote: > > How do I connect to multiple mySQL databases using Prepared Statements ? > > I have the syntax > > === > $dsh = 'mysql:host=localhost;dbname='.$database3; > $dbh = new PDO($dsh, $username, $password); === > > I want to connect to $database1 without loosing my $database3 > connection > $dsh = 'mysql:host=localhost;dbname='.$database3; $dbh = new PDO($dsh, $username, $password); $dsh2 = 'mysql:host=localhost;dbname='.$database1; $dbh2 = new PDO($dsh2, $username2, $password2); Now you can use $dbh for $database3, and $dbh2 for $database1... - Matijn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
