Trouble connecting to database.

babyloniantg

I am having touble simply connecting to the database. I've already installed both php and mysql, and I made sure php knows about mysql (this isn't a "call to undefined function..." mistake). The code looks something like:

$connect_result = mysql_connect($host, $user, $password);
if(!$connect_result)
{
echo "error";
}
else
{
echo "no error";
}

The script always returns error, and I've made sure all the variables that are going in work. Does anyone have any suggestion as to what could be causing this problem?

Roger_Ramjet

Try a different approch


$dbcnx = @mysql_connect($dbhost, $dbuser, $dbpass) 
       or die("The site database appears to be down.");

Now if the connection fails you'll get a message, otherwise you have a connection.

Roger_Ramjet


function dbConnect($db="") { 
   global $dbhost, $dbuser, $dbpass; 

   $dbcnx = @mysql_connect($dbhost, $dbuser, $dbpass) 
       or die("The site database appears to be down."); 

   if ($db!="" and !@mysql_select_db($db)) 
       die("The site database is unavailable."); 

   return $dbcnx; 
}

tomhath

See if php tells you what the error is:

$connect_result = mysql_connect($host, $user, $password) or die(mysql_error());

babyloniantg

Wow, that's really strange. I used

mysql_connect($host, $user, $pass) or die(mysql_error());

instead of the boolean if statement before and it worked! I'm pretty sure I started the mysql service when I was using the if statement. I can't figure out why the first method didn't work. I guess I'll use "or die()" from now on, but I'd really like to find out why it didn't work. Thanks for the feedback, by the way.