RE: [PHP-DB] accessing two databases within one script

Of course you can $whatever_db_linkid = mysql_connect($connectiondetails_for_whatever_db); if(is_resource($whatever_db_linkid)) { mysql_select_db('whatever_db', $whatever_db_linkid); } $someother_db_linkid = mysql_connect($connectiondetails_for_someother_db); if(is_resource($someother_db_linkid)) { mysql_select_db('someother_db', $someother_db_linkid); } // work your magic.. mysql_close($whatever_db_linkid); mysql_close($someother_db_linkid); -----Original Message----- From: Gary Rachel [mailto:gcrachel@hotmail.com] Sent: den 5 oktober 2004 04:31 To: php-db@lists.php.net Subject: [PHP-DB] accessing two databases within one script I have a page where I need to access two different databases in mysql. After accessing the first database I used mysql_close($connection); and then code to access the other database. The first database access works fine, the second gives me the following error message: *Warning*: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' I've tried not using the mysql_close statement. But that option doesn't select the new database, it seems to stay connected to the previous one, despite my specifying a new database to access. Can I not access two databases within the same script? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php