query($qVals111);
$nrows2 = mysql_num_rows($result2);
for($j=0;$j<$nrows2;$j++){
$row2 = mysql_fetch_array($result2);
$theCB = "Bob".$row2["MemId"];
// echo $theCB;
$theCurrentVal = $_POST[$theCB];
// echo $theCurrentVal;
if ($theCurrentVal == "OFF"){
$qVals999 = "INSERT INTO unit_mems (UnitId,MemId) VALUES (".$theUnitId.",".$row2["MemId"].")";
// echo $qVals99." ";
$result3 = $connector->query($qVals999);
$row3 = mysql_fetch_array($result3);
}
}
echo '';
} // END SUBMITTED DATA
// GET THE ORG DETAILS
// THROW THEM INTO VARIABLES
$qVals11 = "SELECT * FROM org WHERE OrgId =".$_SESSION['McMember_OrgId'];
$result = $connector->query($qVals11);
// Get the result
$row = $connector->fetchArray($result);
$OrgName = $row["OrgName"];
$OrgNumber = $row["OrgNumber"];
// >> GET MEMBER PERMISSIONS
// CHECK PERMISSIONS OF THE USER TO SEE WHAT THEY CAN DO WITH MEMBERS
// POPULATE SESSION PERMISSIONS BASED ON THOSE VALUES.
if(isset($_GET['ID'])){
$theUnitId = $_GET['ID'];
}
// echo $theUnitId;
// >> PULL UP THE DATA TO BE USED IN THE LIST
$NotIn = "SELECT MemID FROM unit_mems WHERE UnitId=".$theUnitId;
$qVals11 ="SELECT * FROM oda LEFT JOIN mem ON oda.MemId = mem.MemID WHERE ((OrgId =".$_SESSION['McMember_OrgId'];
$qVals11 = $qVals11.") AND (mem.Deleted=0) AND (oda.MemID NOT IN (".$NotIn."))) ORDER BY mem.LastName";
// echo $qVals11;
$result = $connector->query($qVals11);
$record_found = mysql_num_rows($result);
$nrows = mysql_num_rows($result);
// $row = $connector->fetchArray($result);
print "";
print "";
?>