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: <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]