Two MySQL connections in one script not working as expected

From: Date: Tue, 27 Sep 2005 18:25:52 +0000
Subject: Two MySQL connections in one script not working as expected
Groups: php.general 
Request: Send a blank email to php-general+get-223301@lists.php.net to get a copy of this message
Hi all, I have a script that needs to update data in two databases. My db connections are both in class files that I created to execute the various connections and queries. What is happening is that the second database connection does not seem to work. The error I get is that it seems the second query is being executed against the first database connection - does that make sense? So I get an error that the database_name.table_name does not exist, which is true, but the query is getting executed against the wrong database name. Any ideas? Thanks, Charles

« previous php.general (#223301) next »