Please ignore. Newbie error.... solved Thanks From: Ernie Kemp [mailto:ernie.kemp@xxxxxxxxxxxx] Sent: July-28-09 9:34 PM To: php-general@xxxxxxxxxxxxx Subject: Access Denied 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 <http://localhost/phpmyadmin/tbl_change.php?db=testDB&table=auth_users&prima ry_key=+%60auth_users%60.%60id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60auth_us ers%60&goto=sql.php&token=2e38a21d8832de9283320672387b55c7> Edit <http://localhost/phpmyadmin/sql.php?db=testDB&table=auth_users&sql_query=DE LETE+FROM+%60testDB%60.%60auth_users%60+WHERE+%60auth_users%60.%60id%60+%3D+ 1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3DtestDB%26ta ble%3Dauth_users%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560auth_users%2560% 26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php%26 token%3D2e38a21d8832de9283320672387b55c7&token=2e38a21d8832de9283320672387b5 5c7> Delete1 John Doe john@xxxxxxx jdoe *0AAD744979343D58A7F17A50E514E6AD6533D04B Message from Firefox Browser: Warning: mysqli_connect() [function.mysqli-connect <http://localhost/AllInOne/25/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
