Connecting half the time...

Napster

I made a bunch of scripts for a site and all of them have a file that they all include, "common.php" and that is the script that includes all my pre made functions along with the database connection which looks like:

  $jdbconnect = mysql_connect("localhost", $table, $pass);

  mysql_select_db($database, $jdbconnect);

Of course I actually have the values in there instead of those variables. That is just for privacy. Anyways, the owner of the site downloaded a polls script to the site and added it and all that stuff is in a seperate database and it connects in the files that came with the script so the connections are in two different files. The poll is in the layout of the site. Now since that has been added, whenever I go to a my scripts it gives me an error saying that the database doesnt have the table. Now if I go to a script without the polls on it, it works perfectly.

Now what puzzles me is the error that says, "Table 'wdzone_adpo1.games' doesn't exist". Now my connection connects to a database called games not adpo1, that is the other database with the polls in it. Games is in the database called games. So somehow it is stopping my connection to the other database and is staying connected to the other database.

Any suggestions on how to fix this, or what is causing it? Thanks in advance.

Drakla

Is the handle for the other connection using the same name as your variable $jdbconnect? If so as soon as he uses his use db statement yours will be switched to that, too.

Is the connection to the server using exactly the same credentials as you are? If so you should consider using the optional 4th parameter to get a genuinely new connection resource, as if you're not then again when he picks the database yours will be changed too.

Are you specifying the link identifier as the 2nd parameter in EVERY mysql_query ? If not then maybe, just maybe, the default connection was switched to the other database because the link identifier wasn't used in that.

Napster

Well I know it is not the first two because for the parameters of those two functions, I put them in directly and not in a variable like I have in the example. I have the example like that so I do not give out my database connection info.

It looks something like this:

  $jdbconnect = mysql_connect("localhost", "username_databaseuse,"password"); 

  mysql_select_db("games", $jdbconnect);

Now it is not the second idea because originally I had it without the $jdbconnect variable and it did the same thing.

Now I am not too sure what the third idea means, I know PHP just not all the technical words to it. Could you explain it to me again in lamens terms please and thank you.

Drakla

When you use mysql it has a sort of 'nameless' default connection, as in you can run mysql_connect and not take the value of the handle it returns. Then when you do mysql_query if you don't specify a connection for the second parameter then it just uses the last one that was opened, so if this happens

You connect
You specify your usual database

in the included poll script:
The poll script connects
Poll database chosen

mysql_query($query) is run in your script with no 2nd parameter specifying the connection - it's using the poll database, not the one you used at the start.

Napster

Ok that make sence, however the scripts go like this:

<?php

  //include layout

    // Includes Poll

    // Connects to Poll DB

  // Connects regular connection in common.php

  // Script

Drakla

Then it could be that you're not specifying the 2nd parameter in your mysql_query commands (which you don't really have to on 1 connection scripts ) and because you DID specify the connection in your select_db the poll script may well have changed the default one.

You could either add the 2nd parameter in, or change your queries to use absolute database.table references.

UPDATE: I've just run some tests with two connections, and the default one mysql_query uses is always the last one opened, whether you specify the connection or not when you select the database.

So do you know if any of the poll functions are called later in the script, and maybe the database is chosen later on?