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. // >> PULL UP THE DATA TO BE USED IN THE LIST $qVals11 = "SELECT mem.MemID, mem.FirstName, mem.LastName, mem.Phone_Display, oda.OrgId, img.img_id FROM (mem INNER JOIN oda ON mem.MemID = oda.MemId) LEFT JOIN img ON mem.MemID = img.MemId WHERE oda.OrgId =".$_SESSION['McMember_OrgId']." 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); // $row = $connector->fetchArray($result); 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']; $EditURL = "EditMemberImages.php?ID=" . $row['MemID']; print ""; // ---------------------------------------------------------- $theString = "'; print ""; } // END FOR print "

FUNCTION	"; print "Name	"; print "IMAGE
".$theString; // ---------------------------------------------------------- print "	" . $row["FirstName"]." ".$row["LastName"]; if (!empty($row["Phone_Display"])){ print ", ".$row["Phone_Display"]; } if (!empty($row["img_id"])){ print "	"; } else{ print "	"; } print "

"; print ""; ?>