Bastien Koert

On 2012-05-19, at 2:36 PM, "Ron Piggott" <ron.pigg...@actsministries.org> 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

Reply via email to