RE: [PHP] Two MySQL connections in one script not working as expe cted

From: Date: Tue, 27 Sep 2005 18:28:01 +0000
Subject: RE: [PHP] Two MySQL connections in one script not working as expe cted
Groups: php.general 
Request: Send a blank email to php-general+get-223302@lists.php.net to get a copy of this message
[snip] 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. [/snip] We'd have to see some code, but my bet is that you use the same connection on your mysql_query statement.

« previous php.general (#223302) next »