Well, im sure that there is all the data needed. the echo command during the loop is my experiment, which shows that no data gets in to $row['username'] and $row['password'] and thats so bizzare becuase the data is surely there. you can also watch it here http://shaymaz0r.phpnet.us/login.php . user 111 pass 111 is in the DB so you can see the problem. this is the code: [code] <? if ($_POST['submit']) { mysql_connect('xxx','dasdasdas','sdasda'); mysql_select_db('shaymaz0r'); $query=mysql_query("SELECT * FROM tblusers"); $user=$_POST['username']; $pass=$_POST['password']; $ok=0; while ($row = mysql_fetch_array($query) && $ok==0) { $dbuser=$row['username']; $dbpass=$row['password']; echo("$dbuser $dbpass |||"); if ($user==$dbuser) { if ($pass==$dbpass) { $cookievalue=$row['ID']; setcookie("soda", $cookievalue); header('Location: http://shaymaz0r.phpnet.us/main.php'); } else { $ok=1; } } } if ($ok==1) { echo("<h3 color='red'>Wrong Password.</h3>"); } else { echo("<h3 color='red'>Wrong Username.</h3>"); } mysql_close(); } ?> <html> <head> <title>Login page</title> </head> <body> <center> <br><br> <h1>Login Page</h1> <br> <form method="post" action="login.php"> <h2>Username:</h2><input type="text" name="username"><br> <h2>Password:</h2><input type="password" name="password"><br> <h2><input type="submit" value="Login Now" name="submit"></h2> </form> </body> </html> [/code] thank you very much.
