On 2011-09-30, at 8:26 PM, "Ron Piggott" 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