session_start(); // Gets rid of all the error reporting on servers which are not configured appropriately. error_reporting(E_ALL ^ E_NOTICE); $MSOFinal = $_SESSION['McMember_SO']; $SearchStringFinal = $_SESSION['McMember_SS']; $SearchIsValid = $_SESSION['McMember_SearchIsValid']; if(isset($_SESSION['McMember_SS'])){ $theMCID=33; } else{ $theMCID=2; } // 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 $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. // 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 "