You will use the mysql_select_db() function. It sets the currently active database. You will call this function each time you wish to change which database is being used prior to issuing a query.
You need to open only one connection as long as the databases are on the same server. If you are using multiple servers, you will require a connection to each with unique resource link_identifiers. Then you will have to include the desired resource link_id in each call to mysql_select_db(). There is no need to close and re-open connections between each use. Doug On Sat, 29 Mar 2003 19:09:28 -0800 (PST), Lonnie Cumberland wrote: >Hello All, > >I am new to using PHP with MySQL and was wondering if anyone had a simple >example of how to have multiple active connections to two MySQL databases in a >single script? > >I will have to access two different databases but am not sure how to keep the >active connections and make different queries to each one without having to >open one database, make a query, close it, then open the other database and >make it's query. > >This should be possible I think. > >Any help would be greatly appreciated, >Lonnie Cumberland > > >__________________________________________________ >Do you Yahoo!? >Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! >http://platinum.yahoo.com > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php