accessing two databases within one script
| From: | Gary Rachel | 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?