Can't select database

Anon

I am using the following code to connect to a local database:

$db_name = "MyDB";

$conn = mysql_connect("localhost", "MyName", "MyPassword") or die ("Couldn't connect.");

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

Everything works fine, as expected, until I try to switch the database. Then it always fails at the select_db statement.

For example, if I try to use another database as:

$db_name = "AnotherDB";

this dies with the error "Cannot select local database . . . "

IOW, it connects, but won't select!

I can see this other database from the MySQL monitor, even list its tables, so I know there is nothing wrong with it.

Very weird, and has had me puzzled for weeks. Basically, MySQL is telling me that I can only have one database it will connect to!

Even switching DB's at the monitor with the "use DB" command does not help (altho the monitor works just fine, but not this script).

Any suggestions would be appreciated.

Anon

What happens if you create a new connection before selecting another database? Then select the other database with the new connection. I know it's hoky and stupid for me to ask, but since no one else has posted, I figured "What the hell?" This is definitely not anything I have seen before so I'm just taking a guess. Good luck.

Aaron Zoller
www.AaronZoller.com

Anon

I've tried all sort combinations with that. It always comes back and says "Can't select database" (my error message on the selection failure).

This is very strange. The connection is good, but I just can't select any database, other than the one I set up originally (from Meloni's book, Chap. 1). I even reinstalled MySql (latest version from the web).

The spooky part is, the MySql monitor allows me to do whatever I want with the other databases. I am starting to wonder, since this is a coding issue, if somehow Apache is getting in the way here. But that seems to me to be ridiculous.

Also, I use a program called MySql Front, a replacement for that DOS-like monitor. It also sees all the databases and allows me to work with them.

The only thing left is the PHP interperter itself. But, again the exact same code fails. So if it is a PHP issue, then all I can say is PHP likes one data base and not the other.

marcusthelander

Hi!

I am currently fighting with this problem, where there is no problem with connecting my local database but i can not do the selection part of that specific database. I can use it, show it and all that in the terminal (mac user) but i cant implement this basic command in PHP.

Did you ever found a solution? I would be more than very happy to read a bout it.

Thanks in advance!!!
/Desperate

bradgrafelman

marcusthelander;10993856 wrote:
Hi!

I am currently fighting with this problem, where there is no problem with connecting my local database but i can not do the selection part of that specific database. I can use it, show it and all that in the terminal (mac user) but i cant implement this basic command in PHP.

Did you ever found a solution? I would be more than very happy to read a bout it.

Thanks in advance!!!
/Desperate

Considering that this thread is almost a decade old (you can tell it's even before the current version/installation of the forums since every post is made by an Anonymous account), you're going to be much better off if you post a new thread and show us some code and error messages that describe the problem you're having.