RE: [PHP] Two MySQL connections in one script not working as expe cted
| From: | Jay Blanchard | 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.