COnnection probs.

[roberto_badgio]

sorry to post another topic, but I think I have the better question to ask now, as i think i asked to broad a question the first time .sorry.

I am trying to connect to the database, and I'm not sure what to put in the "localhost" bit:

mysql_connect(localhost,$username,$password);

what should i put instead of localhost, as local host doesn't seem to work.

I am hosted by webfusion, howevwer, in phpmyadmin it says something about host europe:

MySQL 3.23.58 running on Host Europe as [e-mail]

and im very confused about what i should put in that space, if anyone could help, it would be gr8.

thanks.
Robert

[Roger_Ramjet]

//this file will create the connection
<?php // db.php 

$dbhost = "localhost"; 
$dbuser = "username"; 
$dbpass = "password";

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; 
} 
?>

//this is how you include and use it in your other pages
<?php  //index.php

include_once './db.php';
dbConnect("database name");

?>

The name 'localhost' is a string and so need to be quoted in the connect function. But use the script above, it is more robust and is reuseable throughout your site.

[roberto_badgio]

thanks for the script, it works great, and is much easier, but ive changed hosts now so my mysql works now anyway, but i'll change the way i log in to that now. thanks 4 the help