Posted by Jay Blanchard on 09/27/05 21:28

[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.

[Back to original message]