Unable to Select Database ->0:

[nbhanji]

First:
I am using centos 4.2, same problem occurs for me on fedora FC4, FC2, and
also MACOSX.

mysql version 4.1.12
php 4.3.9
apache 2.0.52

above configuration is for centos 4.2 just built it.

here is the code:

$db_host = "localhost";
$db_user = "test";
$db_pass = "";
$db_db = "test";

$dbh = mysql_connect($db_host,$db_user,$db_pass) ||
die ("Unable to Connect to Database Server ->".mysql_errno().":"
.mysql_error());
echo $dbh;
$dbh = mysql_select_db($db_db,$dbh) ||
die ("Unable to Select Database->".mysql_errno().":" .mysql_error());
mysql_close() || die ("Unable to Close->".mysql_errno().":"
.mysql_error());

output that I get is:
1Unable to Select Database->0:

i can connect to mysql using cli
mysql -u test
output:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

I checked the error_log and the output is:
[client 127.0.0.1] PHP Warning: mysql_select_db(): supplied argument is
not a valid MySQL-Link resource in
/home/nbhanji/Sites/Library/functions.php on line 10

I have been searching for last few days for anything that can help and I
cant get anywhere. Please HELP !!!!!!!!!!!!!!!!

Thanks in advance

Nick Bhanji

[tomhath]

Look carefully at the output of the script:

1Unable to Select Database->0:

The 1 tells me that the connect worked, and you got a valid resource identifier back (the 1)

The 0 at the end tells me that the select database worked.

But then something else went wrong that caused it to die.

One thing that looks strange is that you are overwriting $dbh in the call to mysql_select_db.

$dbh = mysql_select_db($db_db,$dbh) || ...

Try removing the assignment to $dbh, I think your setup is okay.

[bpat1434]

I'd say you have an error connecting....

If you connected properly, you'd have a proper mySQL resource link identifier.

Echo out $dbh after you attempt to connect:

$dbh = mysql_connect($db_host, $db_user, $db_pass) or die('Unable to Connect to Database -> '.mysql_errno().':'.mysql_error());
echo $dbh;

[jazz_snob]

I agree w/ tomhath

// this is not a good idea since the call returns a boolean value
$dbh = mysql_select_db($db_db,$dbh) 

//better
if ( mysql_select_db( $db_db, $dbh ) === FALSE ) {
  die( "Failed to connect to $db_db: " . mysql_error());
}