<?php

	$dbhost="radonmedical.db.4024795.hostedresource.com";
	$dbname="radonmedical";
	$dbuser="radonmedical";
	$dbpass="Radonwv1";

	mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
	mysql_select_db($dbname) or die(mysql_error());

	session_start();
	$username = $_POST['username'];
	$password = $_POST['password'];

	$query = "select * from users where username='$username' and password='$password'";

	$result = mysql_query($query);

	if (mysql_num_rows($result) != 1) {
		$error = "Bad Login";
		echo '<div id="error">The username and/or password provided is incorrect.</div>';
		include "loginform.php";
		include "footer.php";
	}

	else {
		$_SESSION['username'] = "$username";
		include "memberspage.php";
	}

?>