Re: MySQL database query passwort and username

> 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?

You will get more answers asking your questions in the database mailing
list  [email protected], rather than in a list for Windows related
matters.

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

--
Niel Archer



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