session_start();
header("Cache-control: private"); //IE 6 Fix
$_SESSION['McMember_SpecialTitle'] = "Edit Group Member";
// Gets rid of all the error reporting on servers which are not configured appropriately.
error_reporting(E_ALL ^ E_NOTICE);
// Get the PHP file containing the DbConnector class
require_once('DbConnector.php');
// Create an instance of DbConnector
$connector = new DbConnector();
$theOrgId = $_SESSION['McMember_OrgId'];
$theMemId = $_SESSION['McMember_MemId'];
$thehiddenSubmitter = $_POST['hiddensubmitter'];
$GrpName=$_POST['Name'];
$GrpCategory=$_POST['Category'];
$GrpFunction=$_POST['Function'];
$GrpStatus = $_POST['Status'];
$GrpYears = $_POST['Years'];
$GrpResults = $_POST['Results'];
$GrpBudget = $_POST['Budget'];
$GrpProject = $_POST['Project'];
$GrpDescription = $_POST['Description'];
$theGrpId = $_POST['GroupId'];
If ($thehiddenSubmitter == "pookachoo"){
// THROW THE INFO INTO A GROUP RECORD
// -----------------------------------------------------------------
$FieldNames = "Name,Category,Description,Function,Project,Budget,Results,ActiveYears,Status,OrgId,CreateDate,CreatedBy";
$FieldValues = "'$GrpName','$GrpCategory','$GrpDescription','$GrpFunction','$GrpProject','$GrpBudget','$GrpResults','$GrpYears','$GrpStatus',$theOrgId,CURDATE(),$theMemId";
$qVals = "UPDATE grp_mems SET Role='$GrpCategory',Responsibilities='$GrpDescription',Position='$GrpFunction' WHERE Grp_MemId=".$theGrpId;
// echo $qVals;
$result = $connector->query("$qVals");
echo '';
}
if(isset($_GET['ID'])){
$theGrpId = $_GET['ID'];
}
$qVals11 = "SELECT grp_mems.Grp_MemId, grp_mems.Grp_MemId, grp_mems.GrpId, grp_mems.MemId, grp_mems.Role, grp_mems.Position, grp_mems.Responsibilities, mem.FirstName, mem.LastName, mem.Phone_Display, mem.Email FROM grp_mems LEFT JOIN mem ON grp_mems.MemId = mem.MemID WHERE grp_mems.Grp_MemId=".$theGrpId; // echo $qVals11;
// echo $qVals11;
$result = $connector->query($qVals11);
$record_found = mysql_num_rows($result);
$nrows = mysql_num_rows($result);
$row = $connector->fetchArray($result);
?>