Login problem

Anon

I\'m trying to verify if people are using the correct password and username.
First I post from a HTML document the variables $wachtwoord and $usernaam
Next is the database connection where I try to get matching information.
Now there should be matches because the database is filled.
But I get an incorrect login each time I try to login...
What am I doing wrong?

$query = \"SELECT username,passwd FROM geintje WHERE username = \'$usernaam\' AND passwd = \'$wachtwoord\'\";
$result = mysql_query($query);
echo mysql_error();
$row = mysql_fetch_row($result);
$passwd = $row[\'passwd\'];
if ($wachtwoord==$row[\'passwd\']){
header (\"Location:http://www.tools-and-design.com/rate.php\");
}
else{
echo \"Incorrect login\";
}

[deleted]

Hi,

I would get the number of rows returned. If you get 1 then you don't have to check for the password again since you already did in the query!

Also, you should use mysql_fetch_array if you want to do something like "$row["passwd"]. If you do mysql_fetch_row you should use $row[1];

$query = "SELECT username, passwd FROM geintje WHERE username = '$usernaam' AND passwd = '$wachtwoord'";

$result = mysql_query($query);
echo mysql_error();

$num = mysql_num_rows($result);
if ($num == 1) {
echo ("Welcome");
} else {
.. something wrong.. either the user or password wrong. If num > 1 then you have a database problem.
}