Done both.

In fact, I create an object which has 2 database objects in it.
If I dump the objects, I can WATCH as they "merge" and point 
at the same database.

I go back to using mysql_db_query() and everything's fine.
It would appear that the mysql_select_db() is not persisting.
If you call it on two different links, it's seems to modify both
links.  Almost like it's global....



----- Original Message ----- 
From: "Paul Burney" <[EMAIL PROTECTED]>
To: "Szii" <[EMAIL PROTECTED]>; "php mailing list" <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 2:28 PM
Subject: Re: [PHP-DB] MySQL Modules and multiple database

> on 8/13/01 1:56 PM, Szii ([EMAIL PROTECTED]) wrote:
> > Opening multiple databases on the same database machine
> > seems unsupported.  While you CAN do it, it has a tendency
> > to "reuse" the last connection even in lieu of a specific database.
> > Right now we're using mysql_db_query() to get around it, but
> > with that becoming deprecated, we need to find anothe solution.
> Before each query (from a different database), you can call the function;
> mysql_select_db($database_name, $connection_id)
> You can also specify the connection id for your queries:
> mysql_query($query, $connection_id)
> Just make sure that you select the db before each query otherwise a query
> will use the last selected database.
> Sincerely,
> Paul Burney
> +-------------------------+---------------------------------+
> | Paul Burney             | P: 310.825.8365                 |
> | Webmaster && Programmer | E: <[EMAIL PROTECTED]>   |
> | UCLA -> GSE&IS -> ETU   | W: <> |
> +-------------------------+---------------------------------+

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to