Two Database Connections, One Page....HELP!

Mystikal

Okay, I wrote my own mysql handler, and it does everything just fine......except when I install my CMS on my windows box (I need to work out weird things on the win box so I can make sure this program will work for both linux and windows users.

Okay, here it goes.

Two connections are made, one to the accounts database, and one to the data database. Both databases are on the same server, same user, same password, but in live they won't be on the same user (same box, yes).

My first connection, called $account->conn works fine. Now.. my second one will work to a point, but then will forget which database it is using and only be able to select stuff from the accounts database. WTF?!?

Since then, I've encountered some weird workarounds.. For instance... I put the following code in my template() function and it just magically starts knowing what to do again.. ($c->conn is the data database conn btw).

$tables = mysql_list_tables($c->conn->db);
while( $row = mysql_fetch_object($tables) ) {}

Found this happened on some other places too, put in this code and BOOM, it worked.

WTF?!?

Anyone know why this is happening.. why would those 2 lines all of a sudden fix EVERYTHING? Could this be a bug in mysql, or what?

jeremuck

The bug is almost certainly in your mysql handler.

I dont' think anyone will be able to help you without more information.

my second one will work to a point, but then will forget which database it is using and only be able to select stuff from the accounts database.

What is the point at which it stops working?
When does it "forget"? Have you tried printing out your variables to the screen to see what it's doing?
Personally I find:

<?php
echo "<pre>\n";
print_r($GLOBALS);
echo "\n</pre>";

?>
to be particularly helpful.
And if I had objects that were acting wierd, I'd make special functions if I had to in order to dump ALL the information to the screen. Only when I can see every tid-bit will I be able to find the problem. I'm sure many others feel the same way.
Otherwise, you are just "Poking it with a stick till it works" which isn't a true fix to any problem.

Mystikal

I fixed it.

It was getting confused which connection to use because they were using the same account to connect. It was not a code problem.