accessing two databases within one script

From: Date: Tue, 05 Oct 2004 02:31:15 +0000
Subject: accessing two databases within one script
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-36601@lists.php.net to get a copy of this message
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?

« previous php.db (#36601) next »