session_start(); header("Cache-control: private"); //IE 6 Fix $_SESSION['McMember_SpecialTitle'] = "Edit Group"; // 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 SET Name='$GrpName',Category='$GrpCategory',Description='$GrpDescription',Function='$GrpFunction',Project='$GrpProject',Budget='$GrpBudget',Results='$GrpResults',ActiveYears='$GrpYears',Status='$GrpStatus' WHERE GrpId=".$theGrpId; // echo $qVals; $result = $connector->query("$qVals"); echo ''; } if(isset($_GET['ID'])){ $theGrpId = $_GET['ID']; } $qVals11 = "SELECT * FROM grp WHERE OrgId =".$_SESSION['McMember_OrgId']." AND Deleted=0 AND GrpId=".$theGrpId; // echo $qVals11; $result = $connector->query($qVals11); $record_found = mysql_num_rows($result); $nrows = mysql_num_rows($result); $row = $connector->fetchArray($result); ?>