<?php
   include("config.php");
   session_start();

   if($_SERVER["REQUEST_METHOD"] == "POST") {
	  // username and password sent from form

	  $myusername = mysqli_real_escape_string($db,$_POST['username']);
	  $mypassword = mysqli_real_escape_string($db,$_POST['password']);

	  $sql = "SELECT userID FROM users WHERE userName = '$myusername' and pass = PASSWORD('$mypassword')";
	  $result = mysqli_query($db,$sql);
	  $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
	  $active = $row['active'];

	  $count = mysqli_num_rows($result);

	  // If result matched $myusername and $mypassword, table row must be 1 row

	  echo "test";

	  if($count == 1) {
		 session_register("myusername");
		 $_SESSION['login_user'] = $myusername;

		 echo "logged in";
	  }else {
		 $error = "Your Login Name or Password is invalid";
	  }
   }
?>