Mysql need help starting off

[riley200007]

hey guys

im trying to upload a database into company websites directory i have checked the server using phpinfo and php and mysql are both installed

all i have put up there is a small access database on there with one test record im trying to connect to the damn thing and read the record but all i get is my_sql cannot connect to database, there is no user name or password on the database so i have taken the two varibles away from the

mysql_connect(localhost,$user,$password);

@mysql_select_db($database) or die( "Unable to select database");

 

this is the code i am using bar company details for obvious reasons

 

<?

$database="database.accdb";

 

mysql_connect(localhost);

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM contacts";

$result=mysql_query($query);

 

$num=mysql_numrows($result);

 

mysql_close();

 

echo "<b><center>Database Output</center></b><br><br>";

 

$i=0;

while ($i < $num) {

 

$first=mysql_result($result,$i,"first");

$last=mysql_result($result,$i,"last");

$phone=mysql_result($result,$i,"phone");

$mobile=mysql_result($result,$i,"mobile");

$fax=mysql_result($result,$i,"fax");

$email=mysql_result($result,$i,"email");

$web=mysql_result($result,$i,"web");

 

echo "<b>$first $last</b><br>Phone: $phone<br>Mobile: $mobile<br>Fax: $fax<br>E-mail: $email<br>Web: $web<br><hr><br>";

 

$i++;

}

 

?>

 

and this is what im getting

 

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/psa/home/vhosts/(company address)/httpdocs/test.php on line 11

Unable to select database

 

can any1 please help

cheers

 

 

[effigy]

You're not passing enough parameters to mysql_connect, nor checking to see if it succeeded. See example 1385 here.