//LOG IN

<?php

//$tbl_name ="members"; //table name

//connect
$con = mysql_connect("localhost", "root", "");
if (!$con)
	{
		die('could not connect: ' . mysql_error());
	}

//create database
 mysql_query("CREATE DATABASE my_database",$con) or die ("cannot create databse" . mysql_error());


//create table

mysql_select_db("my_database", $con) ;
$sql = "CREATE TABLE Members (
			firstname varchar(15),
			lastname varchar(15),
			emai varchar(15),
			username varchar(15),
			pass varchar(8),"
or die("connot select db;
" . mysql_error());

//EXECUTE QUERY
mysql_query($sql,$con);

//insert to database from form
$sql="INSERT INTO Members(Firstname, Lastname, E-mail, Username, Password)
		VALUES
		('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[usernam]','$_POST[pass]')" or die ("cannot inset");

		if (!mysql_query($sql,$con))
						{
							die('Error: >' . mysql_error());
						}

		$result = mysql_query("SELECT * FROM Members");

//username and password from form
//TEST USENAME PASSWORD
$username=$_POST['username'];
$pass=$_POST['pass'];


		//Mysql_num_row is counting table row
		$count=Mysql_num_row($result);
		//if result matched username and pass, table row must be one row
			if($count==1) {
				session_register("username");
				session_register("pass");
				echo "Login Successfully";
			}

			else {
				echo"Wrong Username or Password";
			}

mysql_close($con);
?>