You can add the database to your query. Such as: SELECT * FROM database.table WHERE stuff=other_stuff;
I am not sure what other databases support this notation but I know that MySQL does. Eric On Sat, 23 Feb 2002, Thomas Seifert wrote: > Hi folks, > > just wondering, why the mysql_db_query is being abandoned and called > "deprecated" ? > > With the current implementation of the mysql_connect I have a problem > with using 2 databases with the same username/password. > PHP will use the same connection and so only use one of the two > databases :-(. > > Is there any other way than always calling mysql_select_db before making > a query? > I was used using an abstraction layer with a class for each connection > which used also mysql_db_query for the query so that I could use each > class on a different database (but with the same connection parameters). > > Is there a speed penalty in using the combination of > mysql_select_db();mysql_query ... compared against mysql_db_query? > > > Thanks a lot for already reading this ;-) > > Thomas > > > -- Eric Thelin [EMAIL PROTECTED] AZtechBiz.com: Where Arizona Does Tech Business -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php