session_start();
error_reporting(E_ALL ^ E_NOTICE);
function ai($aVal){
if ($aVal==1){
$aStatus = "Active";
}
else{
$aStatus = "Inactive";
}
return $aStatus;
}
$GSOFinal = $_SESSION['McMember_GSO'];
// Get the PHP file containing the DbConnector class
require_once('../DbConnector.php');
// Create an instance of DbConnector
$connector = new DbConnector();
// GET THE ORG DETAILS
// THROW THEM INTO VARIABLES
if(isset($_GET['ID'])){
$theGrpId = $_GET['ID'];
}
$qVals11 = "SELECT * FROM grp WHERE GrpId =".$theGrpId;
$result = $connector->query($qVals11);
// Get the result
$row = $connector->fetchArray($result);
$GrpName = $row["Name"];
$GrpCategory = $row["Category"];
// >> GET MEMBER PERMISSIONS
// CHECK PERMISSIONS OF THE USER TO SEE WHAT THEY CAN DO WITH MEMBERS
// POPULATE SESSION PERMISSIONS BASED ON THOSE VALUES.
// echo $theGrpId;
// >> PULL UP THE DATA TO BE USED IN THE LIST
$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.GrpId=".$theGrpId." AND mem.Deleted=0 ORDER BY mem.LastName";
// echo $qVals11;
$result = $connector->query($qVals11);
$record_found = mysql_num_rows($result);
$nrows = mysql_num_rows($result);
echo "
".$GrpName." - ".$GrpCategory." (".$nrows." Members)
";
// $row = $connector->fetchArray($result);
print "