<?php
ob_start();

include 'config.php';

	mysql_connect($dbHost, $dbUser, $dbPass)or die("Cannot connect to MySQL");
	mysql_select_db("trekkie1_project6")or die("Cannot select DB...");

	// Get the submit details
	$username=$_POST['username'];
	$password=$_POST['password'];

	// Make details safe
	$username = mysql_real_escape_string($username);
	$password = mysql_real_escape_string($password);

	$sql='SELECT * FROM users WHERE username =  '.$username.' AND PASSWORD =  '.$password.' LIMIT 0 , 30;';
	$result=mysql_query($sql);

	$count=mysql_num_rows($result);

	if($count==1){
	session_register("username");
	session_register("password");
	echo' hello logged in';
	}
		else {
			echo "Wrong Username or Password";
			}
ob_end_flush();

?>