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 "
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; // used to call page in new window // VIEW"; for($j=0;$j<$nrows;$j++){ $row = mysql_fetch_array($result); $EditURL = "EditGroupMember.php?ID=".$row["Grp_MemId"]; $DeleteURL = "DeleteGroupMember.php?ID=".$row["Grp_MemId"]; print ""; // ---------------------------------------------------------- // ---------------------------------------------------------- $theString = "'; print ""; } // END FOR print "
FUNCTION"; print "Member Name "; print "Email"; print "Position
".$theString; // ---------------------------------------------------------- // ---------------------------------------------------------- $theString = "'; print "".$theString; // ---------------------------------------------------------- print "" . $row["FirstName"]." ".$row["LastName"]." ".$row["Phone_Display"]; print "" . $row["Email"]; print "" . $row["Position"]; print "
"; ?>
'; print "$theString"; ?>