Database not selected?

[div]

I have the database connection string as a seperate file (dbconnect.php) with the following (I've replaced the name, password and database names, obviously):

 

<?php

$dbh=mysql_connect ("localhost", "name", "password") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("database"); 

?>

 

 

But I keep getting "No database selected" when trying to login. I also get "I cannot add user. No database selected" when using the user creation form. I'm using two databases (one for my domain, one for the subdomain), the main one (on the domain) was not built by me, and the "password" section in THAT dbconnect file is just "password", and when I created the new database there wasn't any option to create a password, so I've just left it as "password" in the new dbconnect file.

 

I copy/pasted the database connection string from the control panel, so I'm surprised it won't work.

[F1Fan]

Try adding your connection variable to it like so:

 

<?php
$dbh=mysql_connect ("localhost", "name", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database",$dbh); 
?>

[div]

Thanks, tried it but it still isn't working.

[fenway]

Do you get an error when using mysql_select_db()?