<?
error_reporting(E_ALL);
//Informatie database
$host = "localhost";
$username = "";
$password = "";
$db_name = "linh7219_shit";
$tbl_name = "members";
die('Debug 2')

//connect to database
mysql_connect($host, $username, $password) or die("Can't connect");
mysql_select_db($db_name) or die("Can't select database");

//login
$myusername = mysql_real_escape_string($_POST['myusername']);
$mypassword = mysql_real_escape_string($_POST['mypassword']);

$sql = "SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword' LIMIT 1";
$result = mysql_query($sql);
die('Debug 1')
$count = mysql_num_rows($result);

if($count==1) {
  session_start();
  $_SESSION['myusername'] = $myusername;
  $_SESSION['mypassword'] = $mypassword;
  header("Location: login_succes.php"); // Should this be success not succes?

  }
  else {
  echo "Wrong Username or Password";
  }
  ?>