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. // count the number of recs in total to be returned $qVals12 = "SELECT * FROM oda LEFT JOIN mem ON oda.MemId = mem.MemID WHERE OrgId =".$_SESSION['McMember_OrgId']." AND mem.Deleted=0".$_SESSION['McMember_SS'].$MSOFinal; $result12 = $connector->query($qVals12); $rCount = mysql_num_rows($result12); // >> PULL UP THE DATA TO BE USED IN THE LIST $qVals11 = "SELECT * FROM oda LEFT JOIN mem ON oda.MemId = mem.MemID WHERE OrgId =".$_SESSION['McMember_OrgId']." AND mem.Deleted=0".$_SESSION['McMember_SS'].$MSOFinal." limit ".$_SESSION['McMember_Min'] .",".$_SESSION['McMember_Max']; // echo $qVals11; $result = $connector->query($qVals11); $record_found = mysql_num_rows($result); if ($record_found){ $nrows = mysql_num_rows($result); // $row = $connector->fetchArray($result); print "
"; 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 = "EditMember.php?ID=" . $row['MemId']; $DeleteURL = "DeleteMember.php?ID=" . $row['MemId']; $ViewURL = "ViewMember.php?ID=" . $row['MemId']; $FlagURL = "FlagMember.php?ID=" . $row['MemId']; $MemSince = date("md-Y",$row['MemberSince']); $BD = date("md-Y",$row['Birthdate']); print ""; // ---------------------------------------------------------- $theString = "'; print ""; } // END FOR print "
FUNCTION"; print "First Name "; print "Last Name"; print "Phone Number"; print "Email
".$theString; // ---------------------------------------------------------- // ---------------------------------------------------------- $theString = "'; print "".$theString; // ---------------------------------------------------------- // ---------------------------------------------------------- $theString = "'; print "".$theString; // ---------------------------------------------------------- print "" . $row["FirstName"]; print "" . $row["LastName"]; print "" . $row["Phone_Display"]; print "" . $row["Email"]; print "
"; print ""; print ""; $backURL = "ViewMembers.php?SO=".$_SESSION['McMember_SONum']."&GFGB=0&MCID=".$theMCID; // echo $backURL; $backURL = "document.location.href='$backURL'"; $theBACKString = " "; if ($_SESSION['McMember_Min'] != 0){ print $theBACKString; } $fwdURL = "ViewMembers.php?SO=".$_SESSION['McMember_SONum']."&GFGB=1&MCID=".$theMCID; // echo $fwdURL; $fwdURL = "document.location.href='$fwdURL'"; $theFWDString = " "; if ($_SESSION['McMember_Max'] < $rCount){ print $theFWDString; } if(!empty($_SESSION['McMember_SS'])){ $ViewURL = "ViewMembers.php?MCID=3"; $ViewURL = "document.location.href='$ViewURL'"; $theString = " "; print $theString; print ""; } print " "; // print ""; echo ''; $StartNum = $_SESSION['McMember_Min'] + 1; if ($rCount<$_SESSION['McMember_Max']){ print "(".$StartNum." - ".$rCount.") of ".$rCount." records..."; } else { print "(".$StartNum." - ".$_SESSION['McMember_Max'].") of ".$rCount." records..."; } echo ''; // print ""; print "
"; } // END IF RECORD FOUND else{ echo ''; print "No Records Found...

"; echo '
'; print ""; } ?>