mysql login script full of bugs ...

[alisam]

thanks for your help, but i tried after your help to code "myown" script and i ended up like this:

<?

if ($login == "ok")
{

$verbindung = mysql_connect("mysql.xxxx.xx", "xxxx", "xxxx);
$sql = "SELECT Name, Passwort FROM Members";
$dbResult = mysql_db_query('edesignz', $sql);
while ($row = mysql_fetch_row($dbResult))
{

if ($row[0] == $user && $row[1] == $pass)
{

$a = $a + 10 ;
}else{

$a = 0 ;

}

}

If ($a == 0 || $a < 10) {

echo "wrong";
}else {

echo "right";

}
}
?>

But it says always wrong, no matter if the username and password is correct or not..

Please tell me my mistake(s)

regards ali

PS: the first filed on my table is Name (username) and the second one is the password field

[khaine]

couple of things that could be the problem. first you access the rows with numbers not keys and the second glaring one is the reseting of $a. If you have ten rows selected and the first is the one you want the other 9 reset $a. Try this modified script.
<?

if ($login == "ok")
{

$verbindung = mysql_connect("mysql.xxxx.xx", "xxxx", "xxxx);
$sql = "SELECT Name, Passwort FROM Members";
$dbResult = mysql_db_query('edesignz', $sql);

$a=0;
while ($row = mysql_fetch_array($dbResult))
{
if ($row['Name'] == $user && $row['Passwort'] == $pass)
{
$a=10;
}
}
If ($a == 0 || $a < 10) {
echo "wrong";
}else {
echo "right";
}
}
?>

That should do it.

Mark.