1  <?php
2 
3  // get application functions
4  require('include/variables.php');
5  require('include/app_functions.php');
6 
7  include('include/win95.scheme.php');
8 
9  siteHeader("Committees Script");
10 
11  pageTop("Membership Database Application: DISPLAY MEMBERS ");
12 
13  bodyTag();
14 
15 
16  // Define $conn
17  $conn = connect();
18 
19  $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
20                          MemberTypes.MemberType FROM MemberTypes
21                          RIGHT JOIN Members
22                          ON MemberTypes.MemberTypeID = Members.MemberTypeID";
23 
24 
25  // if this is a submit process
26    
27  print "<center>";
28    $result = query($getmemberlist);
29    if(!$result) {
30          print error();
31          } else {
32          print "<TABLE>";
33          while($row=fetch_array($result)) {
34              extract($row);
35              print "<tr><td><A HREF=display_thismember.php?MemberID=". $MemberID
36  . "><IMG SRC=user2.gif ALT=\"Members\" BORDER=0></A></td><td>" . $MemberName
37              . "</td><td>" . $MemberType
38              . "</td><td>". $EmailName ."</td></tr>";
39          }
40          print "</TABLE>";
41    }
42 
43  $link_array = array(
44  "Add Member" => "add_member.php",
45  "Add Committee Member" => "add_committeemember.php",
46  "Define A Committee" => "add_committee.php"
47  );
48 
49 
50  navBar($link_array);
51 
52  print "</center>";
53 
54 
55  pageBottom();
56 
57 
58  siteFooter();
59 
60 
61 
62  ?>