mysql_select_db won't work.

[Stinger51]

I have a couple of different databases I've created, we'll call "testdb1" and "testdb2." (I am using PHP 4.0).

I use the following standard code for the connection :

$db_name = "testdb1";
$conn = mysql_connect("localhost", "myname", "pword") or die ("Couldn't connect.");
$db = mysql_select_db($db_name, $conn) or die ("Couldn't select local database -- $db_name");

This works fine, of course.

But when I try to select the other database, "testdb2" I can't select it (it dies) :

$db_name = "testdb2";
$db = mysql_select_db($db_name, $conn) or die ("Couldn't select local database -- $db_name");

I can manipulate both databases from the MySQL monitor, so I know they are properly constructed. But the PHP script refuses to select anything other than testdb1! I'm out of ideas on this one. 😕

[nemonoman]

Try to connect again before selecting the db, or use mysql_pconnect for a persistent connection.

[gtibok]

Try to create another variable to testdb2

$db = mysql_select_db('testdb1') or die('1');
$db2 = mysql_select_db('testdb2') or die('2');

that's how I work , but it must work as you try too. can;t figure out why it doesn't

[Stinger51]

I tried both suggestions, reconnecting and using two different variables. In fact, just trying to connect to "testdb2" won't even work. It's like PHP will connect to one, and only one database -- testdb1 -- and that's it!

Maybe it's time to reinstall MySQL? I'm using the latest download 3.23.47.

Or maybe it's time to upgrade to PHP 4.2?

I hate these "magic fix" upgrades, but who knows.