<?php
mysql_connect("mysql13.000webhost.com","a7876220","brett1")or die("cannot connect");
mysql_select_db("SpecialForces")or die("cannot select DB");
$myusername=$_POST['myusername'];
$myusername = stripslashes($myusername);
$myusername = mysql_real_escape_string($myusername);
$mypassword=$_POST['mypassword'];
$mypassword = stripslashes($mypassword);
$mypassword = mysql_real_escape_string($mypassword);
$result= mysql_query("SELECT * FROM members WHERE username='$myusername' and password='$mypassword'");
$count=mysql_num_rows($result);
if($count==1){
$username = $_SESSION['myusername'];
$password = $_SESSION['mypassword'];
header("Location:login_success.php");
}
else {
echo "LOGIN FAILED!  You entered $myusername for a username and $mypassword for a password.  Please check your login info and try again.";
}
?>