query($qVals11); // Get the result $row = $connector->fetchArray($result); $OrgName = $row["OrgName"]; $OrgNumber = $row["OrgNumber"]; // >> 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".$MSOFinal; // 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 ""; 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']); // ---------------------------------------------------------- $theString = ""; print ""; } // END FOR print "

SELECT	"; print "First Name	"; print "Last Name	"; print "Phone	"; print "Email	"; print "Type	"; print "Status
".$theString; // ---------------------------------------------------------- print "	" . $row["FirstName"]; print "	" . $row["LastName"]; print "	" . $row["Phone_Display"]; print "	" . $row["Email"]; print "	" . $row["MemType"]; print "	" . $row["MemStatus"]; print "

"; ?>