mysql multiple connections can use same pconnect causing grief.

[eluser]Skotos[/eluser]
Yes the problem is with the first two lines of the code. The echos were just there to indicate which tables were being pointing to.
The problem is with mysql. It has to do with the way that mysql_pconnect works. As php.net says:

http://au2.php.net/manual/en/function.my...onnect.php

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second...

I haven't checked other DB engine connection syntaxes. I got around the problem by just creating another mysql user account to allow access to both schemas at the one time.

BTW: I am running CI-1.6 at the moment. Give me 15mins and I'll see if 1.7 is similar.