------=_NextPart_000_0077_01CC7FAF.2FE23520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


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 =3D 'mysql:host=3Dlocalhost;dbname=3D'. $database1;
$dbh =3D new PDO($dsh, $username, $password);


Is there a way to amend this with a second database connection?

Ron



www.TheVerseOfTheDay.info

------=_NextPart_000_0077_01CC7FAF.2FE23520--

On 2011-09-30, at 8:26 PM, "Ron Piggott" <ron.piggott [at] actsministries.org> wr=
ote:

>
> I need my Prepared Statement database connection to be able to connect wit=
h 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 =3D 'mysql:host=3Dlocalhost;dbname=3D'. $database1;
> $dbh =3D 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