It would help to know the database .... but in Mysql
you can just do this: if you connect to one databaseA, it is possible to
grab info from another databaseB by this format:
SELECT * FROM databaseA.TABLE
while at the same time running this query elsewhere in your functions
SELECT * FROM databaseB.TABLE
basically list thedatabase in front of the table, that should be it
Fabian
----- Original Message -----
From: "Michael Roark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 3:20 PM
Subject: [PHP] query 2 databases from one script
> I've a script has many functions in it all of which hit databaseA . I've
> added a new function which is to get data from databaseB how can I go
about
> this in one script when I try to connect to a database other than the one
> defined at the beginning of the script all the functions in the script
> break as if I am setting the wrong database at the top of the script. Any
> help would be greatly appreciated.
>
> Michael Roark
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
