Re: Multiple Database Connection Using Prepard Statements

Bastien Koert

On 2012-05-19, at 2:36 PM, "Ron Piggott" <[email protected]> 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
> 
> Thoughts?  Comments?  
> 
> 
> Ron Piggott
> 
> 
> www.TheVerseOfTheDay.info 

Ron,

MySQL also supports the convention of using the database name in the query so that you don't necessarily need another connection manage

Select field1, field2 ... Fieldn from db2.table_name [where clause]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php