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: LIST COMMITTEES ");
12 
13  bodyTag();
14 
15  // Define $conn
16  $conn = connect();
17 
18  $getmemberpayments = "SELECT Payments.*, PaymentMethods.PaymentMethod
19                          FROM PaymentMethods
20                          RIGHT JOIN Payments ON Payments.PaymentMethodID = PaymentMethods.PaymentMethodID
21                          WHERE MemberID = '$MemberID'";
22 
23 
24 
25  // if this is a submit process
26    
27       
28    $result = query($getmemberpayments);
29    if(!$result) {
30          print error();
31          } else {
32     if(numrows($result) == 0) {
33         print "Member is Not a Member of a Committee";
34     } else {
35          print "<TABLE>\n";
36          print "<tr><th>Payment Method</th><th>Payment Date</th><th>Payment Amount</th></tr>\n";
37            while($row=fetch_array($result)) {
38              extract($row);
39              print "<tr><td align=center>" . $PaymentMethod
40              . "</td><td align=center>" . $PaymentDate
41              . "</td><td align=center>". $PaymentAmount ."</td></tr>\n";
42               }
43              print "</TABLE>\n";
44        }
45    }
46 
47 
48  // print "Committees Script";
49 
50 
51 
52 
53  pageBottom();
54  siteFooter();
55 
56 
57 
58  ?>