$provLoc = "(12:20)";
$provName = Angelwings;
$intel = $_POST['intel'];
$date = date("Y-m-d H:i:s");

if(ereg("The Province of", $intel)) {

	$query = "SELECT count(*) AS c FROM tivoli_intel_prov WHERE provName='$provName'";
	$test = mysql_query($query);

	if($test) {
		$test_array = mysql_fetch_assoc($test);

		if($test_array['c'] > 0) {
			$update= "UPDATE tivoli_intel_prov SET cb='$intel', date='$date', provLoc='$provLoc' WHERE provName='$provName'";
			$updateq = mysql_query($update);
			
			if($updateq) {
				header("location: member-index.php");
				exit();
			}
			else {
				die("Update failed");
			}
		}

		else {
			$qry = "INSERT INTO tivoli_intel_prov (provName, provLoc, cb, date) VALUES ('$provName', '$provLoc', '$intel', '$date')";
			$result = mysql_query($qry);
			//Check whether the query was successful or not
			if($result)	{
				header("location: member-index.php");
				exit();
			}
			else {
				die("Insert failed");
			}
		}

	}
}