< etc if(!empty($SFld1) && !empty($SComp1) && !empty($SCrit1)){ $SStr1 = "mem.".$SFld1.$SComp1."'".$SCrit1."'"; } if(!empty($SFld2) && !empty($SComp2) && !empty($SCrit2)){ $SStr2 = "mem.".$SFld2.$SComp2."'".$SCrit2."'"; } if(!empty($SFld3) && !empty($SComp3) && !empty($SCrit3)){ $SStr3 = "mem.".$SFld3.$SComp3."'".$SCrit3."'"; } if(!empty($SStr1) && !empty($SStr2) && !empty($SStr3)){ $SStringFinal = $SStr1." ".$Op1." ".$SStr2." ".$Op2." ".$SStr3; } else{ if(!empty($SStr1) && !empty($SStr2)){ $SStringFinal = $SStr1." ".$Op1." ".$SStr2; } if(!empty($SStr1) && !empty($SStr3)){ $SStringFinal = $SStr1." ".$Op1." ".$SStr3; } if(!empty($SStr2) && !empty($SStr3)){ $SStringFinal = $SStr2." ".$Op2." ".$SStr3; } if(!empty($SStr1) && empty($SStr2) && empty($SStr3)){ $SStringFinal = $SStr1; } if(!empty($SStr2) && empty($SStr1) && empty($SStr3)){ $SStringFinal = $SStr2; } if(!empty($SStr3) && empty($SStr1) && empty($SStr2)){ $SStringFinal = $SStr3; } } if (!empty($SStringFinal)){ $SStringFinal = " AND ".$SStringFinal; // echo $SStringFinal; } $_SESSION['McMember_SS'] = $SStringFinal; // Get the PHP file containing the DbConnector class require_once('../DbConnector.php'); // Create an instance of DbConnector $connector = new DbConnector(); // 1. GET THE FIELD NAMES AND DISPLAY THEM IN A DROP DOWN LIST. // 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. If ($thehiddenSubmitter == "pookachoo"){ // >> 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".$SStringFinal; // 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']); $RESETURL = "ResetMember.php"; // ---------------------------------------------------------- $theString = "'; print ""; } // END FOR print "

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

"; print "
"; print '

'; // ----------------------------------------------------------'; print "

"; } // END IF SEARCH CRITERIA HAS BEEN SUBMITTED else{ echo '

First Name Last Name AreaCode Phone Email Address Line 1 Address Line 2 City State / Province Country Zip / Postal Code Member Type Member Status Member Since Birthdate Activated Deleted Keyword1 Keyword 2 Keyword 3	Equals (=)
	( AND OR )
First Name Last Name AreaCode Phone Email Address Line 1 Address Line 2 City State / Province Country Zip / Postal Code Member Type Member Status Member Since Birthdate Activated Deleted Keyword1 Keyword 2 Keyword 3	Equals (=)
	( AND OR )
First Name Last Name AreaCode Phone Email Address Line 1 Address Line 2 City State / Province Country Zip / Postal Code Member Type Member Status Member Since Birthdate Activated Deleted Keyword1 Keyword 2 Keyword 3	Equals (=)

  

'; } // END ELSE ?>