mysql_select_db() question/problem

[alamb]

I am having a problem using the mysql_select_db function. I have connected successfully to mysql with a mysql_connect() function but the select db keeps erroring out. Somehow I am not understanding something. In the line: $db = my_sql_select("testdb", $connection) of die ("Couldn't select database."); I always get Couldn't connect to database. Does the "testdb" have to exist already in mysql or will it be created with this statement if it does not exist? The books I have are very vague on this....

[Anon]

it will not be created it has to already be there.

mysql_select_db("db", $connection);

[brandonschnell]

the database has to exist and the user has to have access to the table.

in die() add: die ("Couldn't select database. Reason: " . mysql_error() );

you should get the mysql error then.

[lawnmowerman]

Unless you made a typo, I don't think the problem is with the mysql_select_db() statement. The die() for that statement says "Couldn't select database", while the error you reported was "Couldn't connect to databse", which indicates a probable problem with mysql_connect() or mysql_pconnect().

Also, yes, the database must already exist and you must have permissions to access it.

Hope this helps! 🙂

-Rich