<?
ob_start();
include ("admintasks-dbcon.php");

$memberID = $_POST['memberID'];
$institutionName = $_POST['institutionName'];
$address1 = $_POST['address_1']; 
$address2 = $_POST['address_2'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipCode = $_POST['zipCode'];
$website = $_POST['website'];
$contactName = $_POST['contactName'];
$position = $_POST['position'];
$phoneNumber = $_POST['phone'];
$email = $_POST['email'];

// OPEN CONNECTION ---> 
mysql_connect($hostname,$username,$password);
@mysql_select_db($dbname) or die( "Unable to select database");


 $sql = "SELECT * FROM addMember WHERE email = '{$email}'";
 $res = mysql_query( $sql ) or die( mysql_error );
  
 if ( mysql_num_rows( $res ) > 0 )
 { 
 
session_start(); 
$_SESSION["contactName"] = $contactName;
header("location:alreadyMember.php");
 
 }
 else{
  
 $query="INSERT addMember (
  
             memberID,    
             institution,
             address1,
             address2,
             city, 
             state, 
             zip, 
             website, 
             contactName, 
             position, 
             phoneNumber, 
             email)
  
 VALUES (    '".$memberID."',
             '".$institution."',
             '".$address1."',
             '".$address2."',
             '".$city."',
             '".$state."',
             '".$zipCode."',
             '".$website."',
             '".$contactName."',
             '".$position."',
             '".$phoneNumber."',
             '".$email."')";
  
$result=mysql_query($query) or die("Error in query:".mysql_error()); 

session_start();
$_SESSION["contactName"] = $contactName;
header("location:thankyouforbecomingamember.php");
}
ob_end_flush();
?>