Two MySQL connections in one script not working as expected
| From: | Charles Kline | 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