Hi,
I am using the script below and i keep getting : No such username . . . and the info the database is there, what could be stopping me? The connect file also works fine.
Thanks
Steven
PHP Code:
<?php
/* ADMIN LOGIN */
echo "<title>Admin Login</title>";
include('connect.php');
if ($_POST['submit']) {
$user = $_POST['username'];
$password = $_POST['password'];
$mdpass = md5($password);
$sql1 = mysql_query("SELECT * FROM admins WHERE username = $user");
$r1 = @mysql_num_rows($sql1);
if ($r1 != 1) {
echo "No such username . . .";
die();
} else {
$sql2 = mysql_query("SELECT * FROM admins WHERE password = $mdpass AND username = $user");
$r2 = @mysql_num_rows($sql2);
if ($r2 != 1) {
echo "Incorrect Password";
die();
} else {
echo "Logged In, Thankyou.";
$_SESSION['logged'] = 1;
echo "<a href=\"index.php\">Home</a>";
}
}
} else {
// Form not submit
}
?>
<head>
<style type="text/css">
.text {
font-size:12px;
font-family:Verdana, Arial, Helvetica, sans-serif;
}
</style>
</head><div class="text">
<p>Please use the form below to login to the Admin Control Panel.</p><br />
<form name="login" action="login.php" method="post">
Username: <input type="text" name="username" /><br />
Password: <input type="password" name="pass" /><br /><br />
<input type="submit" name="submit" value="Login"><input type="reset" name="reset" />
</form></div>
Before you post, read our: 
