started all over again...

Anon

I decided to start all over again for my php based login prompt. the only problem I have now is that even with the right username and password entered, it says that the login failed. this is the code:

<?php
$db_name = "novazro";
$connect = mysql_connect('localhost','name removed','password removed');
$db = mysql_select_db($db_name,$connect);
?>

<head><title>Administrator Control Panel</title></head>
<body>
<?php
$query1 = mysql_query("SELECT password FROM adminlogin WHERE username = '$user'", $connect);
while ($row = mysql_fetch_row($query1));{
echo mysql_error();
$password_check = $row['password'];
}

if ($password === $password_check) {
echo "Logged-in";
}
else {
echo "Login Failed";
}
?>
</body>

you can see it in 'action' here: http://novaz3ro.com/admin

any tips on what to change shall be greatly appreciated ;-)

thanx

Anon

while ($row = mysql_fetch_row($query1));{
echo mysql_error();
$password_check = $row['password'];
}

I don't get what you're doing here. You can completely remove the while and just move it to:

$row = mysql_fetch_row($query1);
$password_check = $row['password'];

The while loop is not needed.

You can also try removing === and replacing it with ==.

If those don't work, echo your query, then copy/paste it to the mysql client and see if it runs correctly.

Anon

no clue if it'd make a difference or not, but I code slightly different....

$query1 = "SELECT password FROM adminlogin WHERE username = '$user'";
$result1 = ($db_name, $query1, $connect)
while ($row = mysql_fetch_row($result1));{

Anon

username has to be unique in that table, so go with brian's suggestion