"; } //border: 1px #0099FF solid; ////////////////////////////////////////////////////////////////////// //2. end time loopin for new items. //1. now loop out the data for Committee Chair //2. now loop out the data for Steering Committee Chair //3. now loop out the data for Steering Committee Vice Chair //4. now loop out the data for Steering Committee //5. now loop out the data for Vice Chair //6. now loop out the data for Board Liaisons //7. now loop out the files //8. end time loopin for new items. //9. now loop out the data for Committee Members //10.A Email all //11. now loop out the data for Industry Advisors //12. now loop out the data for Ex-Officio //13. now loop out the data for President //14. now loop out the data for 1st Vice President //15. now loop out the data for Board Members: ////////////////////////////////////////////////////////////////////// switch ($f) { case "1": $controller = "Agreement Procedures Committee"; break; case "2": $controller = "Audit Committee"; break; case "3": $controller = "Industry Advisory Committee"; break; case "4": $controller = "Law Enforcement Committee"; break; case "5": $controller = "Program Compliance Review Committee"; break; case "6": $controller = "Attorneys Section Steering Committee"; break; case "7": $controller = "Agreement Review Committee"; break; case "8": $controller = "Clearinghouse Advisory Committee"; break; case "9": $controller = "Board of Trustees"; break; case "10": $controller = "Dispute Resolution Committee"; break; default: } echo " Committees

$controller

"; /////////////////////////////////////////////////////////////////////////// $db_name = "comhold"; $table_name = "mycommittee"; //databases that store this temporary stuff. include("c:/thisconnector/thisconnector.php"); $db = mysql_select_db($db_name, $connection) or die("Couldn't select database."); /////////////////////////////////////////////////////////////////////////// //1. now loop out the data for Committee Chair /////////////////////////////////////////////////////////////////////////// $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Committee Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; echo " "; }//end the while loop. $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Committee Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo " "; } /////////////////////////////////////////////////////////////////////////// //2. now loop out the data for Steering Committee Chair /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "Steering Committee Chair:

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } echo " "; }//end the while loop. /////////////////////////////////////////////////////////////////////////// //3. now loop out the data for Steering Committee Vice Chair /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee Vice Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "Steering Committee Vice Chair:

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee Vice Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } echo " "; }//end the while loop. /////////////////////////////////////////////////////////////////////////// //4. now loop out the data for Steering Committee /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "Steering Committee:

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Steering Committee:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; echo "       $myfirstname1 $mylastname1 $myjurisdiction1       $email1

"; } }//end the while loop. /////////////////////////////////////////////////////////////////////////// //5. now loop out the data for Vice Chair /////////////////////////////////////////////////////////////////////////// $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Vice Chair:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } if($class != ""){ echo ""; } }//end the while loop. $class = ""; $sql20 = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Vice Chair:' and status = 'Active' order by mylastname "; $result20 = mysql_query($sql20,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result20)){ $class = $row["class"]; } if($class != ""){ echo " "; } /////////////////////////////////////////////////////////////////////////// //12. now loop out the data for Ex-Officio /////////////////////////////////////////////////////////////////////////// $class = ""; $mydesc = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Ex-Officio:' and status = 'Active' "; $result2 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result2)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($class != ""){ echo "
$myfirstname1 $mylastname1
Chair
$mydesc
$myfirstname1 $mylastname1 $mydesc
$myfirstname1 $mylastname1 $mydesc
$myfirstname1 $mylastname1
Vice-Chair
$mydesc
$myfirstname1 $mylastname1
Ex-Officio
$mydesc
"; } } /////////////////////////////////////////////////////////////////////////// //13. now loop out the data for Member at Large /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Member at Large:' and status = 'Active' "; $result2 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result2)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($class != ""){ echo "
"; echo "
$myfirstname1 $mylastname1 $mydesc
Member at Large
"; } } /////////////////////////////////////////////////////////////////////////// //6. now loop out the data for Board Liaisons /////////////////////////////////////////////////////////////////////////// echo "
"; if ($controller != "Clearinghouse Advisory Committee"){ echo "
Board Liaisons
"; } echo ""; if ($controller != "Clearinghouse Advisory Committee"){ $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Board Liaisons:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Board Liaisons:' and lead = '1'and status = 'Active' "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; $lead = $row["lead"]; if($lead == "1"){ $leadlabel = "Lead"; }else{ $leadlabel = ""; } if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } echo ""; }//end the while loop. $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Board Liaisons:' and lead = '0' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } echo ""; }//end the while loop. echo ""; } //////////////////////////////////////////////////////////////////////// //IFTA, Inc. Advisors /////////////////////////////////////////////////////////////////////////// echo ""; $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'IFTA, Inc. Advisors:' and status = 'Active' "; $result2 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result2)) { $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; if($class != "") { echo ""; } } echo ""; echo ""; echo " "; echo ""; /////////////////////////////////////////////////////////////////////////// //7. now loop out the files /////////////////////////////////////////////////////////////////////////// echo "
$myfirstname1 $mylastname1 $myjurisdiction1 $leadlabel
$myfirstname1 $mylastname1 $myjurisdiction1
IFTA, Inc. Advisors
$myfirstname1 $mylastname1

Committee Information
Committee Charter
Committee Member Terms
New Member Guide
Best Practices Guide
Pre-Audit Planning Webinar
Materials
Meeting Minutes Archive
Meeting Minutes 2016
"; echo "

"; echo "
"; echo "
"; $thetime = time(); $cal = $thetime - $maketime; /////////////////////////////////////////////////////////////////////////// //8. end time loopin for new items. /////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////// //9. now loop out the data for Committee Members /////////////////////////////////////////////////////////////////////////// echo "
"; $tempcount = ""; $counter = "0"; $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Committee Members:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); $num_mess = mysql_num_rows($result1); $tempcount = $num_mess/2; $tempcount = ceil($tempcount); //first pass $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Committee Members:'and status = 'Active' order by mylastname LIMIT $tempcount "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $myfirstname2 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; ///this controls the column. $counter +=1; echo ""; }//end the while loop. echo "
Committee Members
$myfirstname1 $mylastname1
$mydesc
"; echo ""; echo ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Committee Members:' and status = 'Active' order by mylastname LIMIT $tempcount, 20 "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $myfirstname2 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; ///this controls the column. $counter +=1; echo ""; }//end the while loop. /////////////////////////////////////////////////////////////////////////// //10.A Vacant /////////////////////////////////////////////////////////////////////////// echo "
$myfirstname1 $mylastname1
$mydesc
"; echo ""; echo ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and status = 'Vacant' order by region "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $myfirstname2 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $status1 = $row["status"]; $region1 = $row["region"]; ///this controls the column. echo ""; }//end the while loop. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if ($controller == "Clearinghouse Advisory Committee"){ $div2 = ""; }else{ $div2 = ""; } echo "
$region1
$status1
"; /////////////////////////////////////////////////////////////////////////// //10.A Email all /////////////////////////////////////////////////////////////////////////// echo ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); while ($row = mysql_fetch_array($result1)){ $email1 = $row["email"]; $email1 = rtrim($email1); $email1 = ltrim($email1); $collect .= "$email1;"; $links = " Click Here."; } $links2 = ""; echo " "; echo "

To contact a member of the committee, please click on a name. To e-mail the entire committee, "; echo "
$links2 $links
         
"; /////////////////////////////////////////////////////////////////////////// //11. now loop out the data for Industry Advisors /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Industry Advisors:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Industry Advisors:'and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; $mydesc = $row["mydesc"]; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } echo " $myfirstname1 $mylastname1 $mydesc"; }//end the while loop. echo ""; /////////////////////////////////////////////////////////////////////////// //12. President /////////////////////////////////////////////////////////////////////////// if ($controller == "Board of Trustees"){ echo "
Executive Committee

"; } $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "
President

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; // $image = $row["image"]; echo "
"; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } if($class != ""){ echo "
Jurisdiction Liasions$myfirstname1 $mylastname1 $myjurisdiction1
      $email1
Committee
"; } }//end the while loop. /////////////////////////////////////////////////////////////////////////// //14. 1st Vice President /////////////////////////////////////////////////////////////////////////// echo "
"; $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = '1st Vice President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "
1st Vice President

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = '1st Vice President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; // $image = $row["image"]; echo "
"; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } if($class != ""){ echo "
Jurisdiction Liasions$myfirstname1 $mylastname1 $myjurisdiction1
      $email1
Committee
"; } }//end the while loop. /////////////////////////////////////////////////////////////////////////// //15. 2nd Vice President /////////////////////////////////////////////////////////////////////////// echo "
"; $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = '2nd Vice President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "
2nd Vice President

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = '2nd Vice President' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; // $image = $row["image"]; echo "
"; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } if($class != ""){ echo "
Jurisdiction Liasions$myfirstname1 $mylastname1 $myjurisdiction1
      $email1
Committee
"; } }//end the while loop. /////////////////////////////////////////////////////////////////////////// //16. now loop out the data for Board Members: /////////////////////////////////////////////////////////////////////////// $class = ""; $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Board Members:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $class = $row["class"]; } if($class != ""){ echo "


Board Members:

"; } $sql = "SELECT * FROM $table_name where committeename = '$controller' and class = 'Board Members:' and status = 'Active' order by mylastname "; $result1 = mysql_query($sql,$connection) or die("Couldn't execute query."); //while to loop entire database while ($row = mysql_fetch_array($result1)){ $myfirstname1 = $row["myfirstname"]; $mylastname1 = $row["mylastname"]; $myjurisdiction1 = $row["myjurisdiction"]; $class = $row["class"]; $email1 = $row["email"]; // $image = $row["image"]; echo "
"; if($myjurisdiction1 == "()"){ $myjurisdiction1 = ""; } if($class != ""){ echo "
Jurisdiction Liasions$myfirstname1 $mylastname1 $myjurisdiction1
      $email1
Committee
"; } }//end the while loop. ?>