Access Denied

["Ernie Kemp" <ernie.kemp@xxxxxxxxxxxx>]

Line in Program:

//connect to server and select database

//connect to server and select database

$mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");

 

//create and issue the query

$sql = "SELECT f_name, l_name FROM auth_users WHERE username = '".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";

$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

 

 

Record in mySQl database:                                                                                             Users        PASSWORD

id f_name l_name email username password 1 John Doe john@xxxxxxx             jdoe            *0AAD744979343D58A7F17A50E514E6AD6533D04B

 

 

Message from Firefox Browser:

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'jdoe'@'localhost' (using password: YES) in C:\wamp\www\rogers\userlogin.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\wamp\www\rogers\userlogin.php on line 13

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in C:\wamp\www\rogers\userlogin.php on line 13

 

This one has got me. 

Please Help.

 

..../Ernie