[PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Alexander Schunk
Hello, i am writing a small login script for a website. The username and passwort are stored in a database in two separate columns. I have it like this: while($dbbenutzer = mysql_fetch_row($sqlbenutzername)) while($dbpasswort = mysql_fetch_row($sqlpasswort)){ echo

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'; while($r = mysql_fetch_row($result)) { $dbbenutzer = $r[sqlbenutzername]; $dbpasswort = $r[sqlpasswort]; }

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'; Don't use values from $_GET without sanitizing first. If using

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Yes. You are correct. Did not include that part, sry. Dont forget mysql_real_escape_string. :) Karl On Apr 29, 2010, at 9:37 AM, Peter Lind wrote: On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass =

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 16:44, Alexander Schunk asch...@gmail.com wrote: Hello, i have it now as follows: while($dbbenutzer = mysql_fetch_assoc($sqlbenutzername))        while($dbpasswort = mysql_fetch_assoc($sqlpasswort)){ You have things very twisted. Check the code posted by Karl - you only