4
Hi everyone
i am having errors with my code to login to a webpage i keep getting errors and when i fix the errors i encounter another problem which keeps saying wrong username or password but the username and password i used to test are correct
here is my code and the table which it is trying to read from contains the fields:
Username
Pword
Email
ID
any help would be greatly apprietiated thanks!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<?php
// Connect to server and select databse.
$con = mysql_connect('localhost','southpaw','spawboxing') ;
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("$southpawboxing", $con);
// username and password sent from signup form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$query = mysql_query("SELECT * FROM onlinedetails WHERE Username='$myusername' AND Pword='$mypassword'");
$result=mysql_query($query);
// Mysql_num_row is counting table row
$count = mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:loginsuccess.php");
}
else {
echo "Wrong Username or Password";
}
?>
</body>
</html>
