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.


Paul Burney

| Paul Burney             | P: 310.825.8365                 |
| Webmaster && Programmer | E: <[EMAIL PROTECTED]>   |
| UCLA -> GSE&IS -> ETU   | W: <http://www.gseis.ucla.edu/> |

PHP Database 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]

Reply via email to