MySQL database query passwort and username

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

i am writing a login script with php and  mysql:

while($dbbenutzer = mysql_fetch_row($sqlbenutzername))
        while($dbpasswort = mysql_fetch_row($sqlpasswort)){


           echo $dbbenutzer[$i];
           echo $dbpasswort[$j];
       if($benutzername == $dbbenutzer and $pass == $dbpasswort){
         echo '<p>Sie haben sich erfolgreich angemeldet</p>';
         echo '<a href="willkommen.html">Willkommen</a>';
              }
        }

       }

I have the username=benutzername in one column and the
password=passwort in the oher column.
Now i use mysql_fetch_row to go through the columns and try to compare
the values given by sql select statement
with the values provided by the user.

The problem is that this code only finds the firs entry moritz and
123456 and not the second. There are two values in the database morith
123456 and thomas thorr. These are sample values for testing only.

Is there an easier way to write a login script?

thank you
Alexander

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux