query("$qVals"); // header("location: ViewMembers.php"); echo ''; } // >> GET ORG ID if($_SESSION['McMember_OrgId']){ // everything is alright }else{ // something has gone wrong, the org id cant be located $_SESSION['McMember_FailureReason'] = "UnableToLocateOrgId"; header("location: Login.php"); } // USED FOR TESTING PURPOSES // $_SESSION['McMember_OrgId'] = 1; // Gets rid of all the error reporting on servers which are not configured appropriately. error_reporting(E_ALL ^ E_NOTICE); // 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. // >> PULL UP THE DATA TO BE USED IN THE LIST if(isset($_GET['ID'])){ $theMemId = $_GET['ID']; } // $qVals11 = "SELECT * FROM mem WHERE MemId=".$theMemId." ORDER BY LastName"; $qVals11 = "SELECT mem.*, img.img_id FROM mem LEFT JOIN img ON mem.MemID = img.MemId WHERE mem.MemId=".$theMemId." 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); ?>
0){ ?>

">
First Name " tabindex="1">
Last Name " tabindex="2">
Title " tabindex="3">
   
Address 1 " tabindex="4">
Address 2 " tabindex="5">
City, State " tabindex="6">,  
Country, Zip " tabindex="9">
   
Email " tabindex="10">
Phone 1

(
" tabindex="11">

)

 " tabindex="12">  - " tabindex="13">
Phone 2

(
" tabindex="15">

)

 " tabindex="16">  - " tabindex="17">
   
Member Since " tabindex="19">
Birthday " tabindex="20">
Comments
TYPE
STATUS

"; } else{ echo "
"; } ?>

IMAGE

    
   
Phone Type
Phone Type
"; } else{ print "

No Records Located"; print "No Member located."; print "To Return to Membership Administration, click here."; } ?>