Voting System

"; echo"

Note: Refine your results by adding more search critieria.

"; if ( findSession($sess,$ID,$Access,$votestep) == $SessVariable ) { echo ""; echo "

Search:

        Email: 

        First: 

        Last:  

        CWID:

"; if($ordst == "" || $ordst == '2') {$ord = "asc"; $ordst = '1';} else if ($ordst == '1') {$ord = "desc"; $ordst = '2';} if( $sortBy == "" ) { $sortBy = "order by Last"; $ordst = "1"; } if($Last != "") { $lastSearch = "Last like \"%$Last%\""; $needWhere = 1; }else{ $lastSearch = ""; } if($First != "" && $Last != "") { $firstSearch = "and First like \"%$First%\""; $needWhere = 1; }else if( $First != ""){ $firstSearch = "First like \"%$First%\""; $needWhere = 1; }else{ $firstSearch = ""; } if($Email != "" && ($Last != "" || $First != "") ) { $emailSearch = "and Email like \"%$Email%\""; $needWhere = 1; }else if( $Email != ""){ $emailSearch = "Email like \"%$Email%\""; $needWhere = 1; }else{ $emailSearch = ""; } if($MemID != "" && ($Last != "" || $First != "" || $Email != "") ) { $idSearch = "and MemID='$MemID'"; $needWhere = 1; }else if( $MemID != ""){ $idSearch = "MemID='$MemID'"; $needWhere = 1; }else{ $idSearch = ""; } if($needWhere) { $needWhere = "where"; }else{ $needWhere = ""; } $findMember = "select MemAutoID,MemID,MemStatus,Last,First,Email from Members $needWhere $lastSearch $firstSearch $emailSearch $idSearch $sortBy $ord "; $findMemberRslt = mysql_query($findMember); if(!$findMemberRslt) { //error_message(sql_error()); echo "

Error: Cannot find member records

"; } else if(mysql_num_rows($findMemberRslt) == 0) { echo "

There are no member records. Search again.

"; } else { echo "

There are a total of: "; echo mysql_num_rows($findMemberRslt); echo " members.

"; echo ""; while ( $rowresults = mysql_fetch_array($findMemberRslt) ) { echo ""; echo ""; echo ""; echo ""; echo ""; if( $rowresults['MemStatus'] == '241') { echo ""; } else { echo ""; } echo ""; } echo "

ID	Last	First	Email	Member

{$rowresults['MemID']}	".stripslashes($rowresults['Last'])."	".stripslashes($rowresults['First'])."	".stripslashes($rowresults['Email'])."	ACE Member	Not a member

"; } } else { echo "

Error: Access Denied

"; echo "

Go Back | Or, re-enter your access information.

"; } ?>