login session help please

[Namraw]

Hi i was tryin to use the Login Session code for my site and i got it working and everything but somethings bugging me and i dont understand whats its all about

it alwyas seems to show "Can't connect to db" even wen u can login using the user and pass i've setup i was wondering why didn't go awy or is still there cos there no point of it i think.

PHP Code:

<? 
// Login & Session example by sde 
// connect.php 

// replace with your db info 
$hostname="localhost"; 
$mysql_login="root"; 
$mysql_password=""; 
$database="test"; 

if (!($db = mysql_connect("$hostname", "$mysql_login" , "$mysql_password"))) 
{ 
  print("Can't connect to mysql.");     
} 
else 
{ 
  if (!(mysql_select_db("$database",$db))) 
  { 
    print("Can't connect to db."); 
  } 
} 
?>

Click here for rest of tutorial

thanks
Namraw

[Namraw]

i do appoligse for postingthis i now realise what i've done wron but was wondering whether ne1 has used this code and could tell me y the enter password comes up wen u click on link_1-3 after login in

Regards

Namraw

[sde]

1. are you developing locally or remotely?
2. "even wen u can login using the user and pass" <-- does that mean you can login from the mysql command line? if not, explain please.

when you can't connect to the db, it is usually permissions.