1  <?php
2  $f=mysql_connect("localhost","root","") or die("Database Down");
3  mysql_select_db("membership");
4 
5  // Get Members
6  $getmembers = "SELECT DISTINCTROW Members.* FROM Members
7                          WHERE Members.MemberID = '$MembersID'";
8 
9 
10  // Get Committees
11  $getcommittees = "SELECT DISTINCTROW Committees.* FROM Committees ORDER BY Committees.CommitteeName";
12 
13 
14  // Get Member Types
15  $getmembertypes = "SELECT DISTINCTROW MemberTypes.* FROM MemberTypes ORDER BY MemberTypes.MemberType";
16 
17  // Get Payment Methods
18  $getpaymentmethods = "SELECT DISTINCTROW PaymentMethods.* FROM PaymentMethods ORDER BY PaymentMethods.PaymentMethod";
19 
20 
21  // Get Member Listing
22  $getmemberlist = "SELECT DISTINCTROW CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName, Members.*,
23                          MemberTypes.MemberType FROM MemberTypes
24                          RIGHT JOIN Members
25                          ON MemberTypes.MemberTypeID = Members.MemberTypeID";
26 
27  // Get Committee Members
28  $getcommitteemembers = "SELECT DISTINCTROW Committees.CommitteeName, CommitteeMembers.CommitteePosition,
29                           CONCAT(Members.FirstName,' ', Members.LastName) AS MemberName, Members.HomePhone,
30                           Members.WorkPhone, Members.Extension, Members.FaxNumber
31                           FROM Members
32                           INNER JOIN Committees ON Committees.CommitteeID = CommitteeMembers.CommitteeID
33                           INNER JOIN CommitteeMembers ON Members.MemberID = CommitteeMembers.MemberID";
34 
35  // Get Payment Sum
36  $getpaymentsum_old = "SELECT DISTINCTROW Members.MemberID, CONCAT(Members.LastName,' ', Members.FirstName) AS MemberName
37                           FROM Members ORDER BY MemberName";
38 
39  // Get Payment Sum
40  $getpaymentsum = "SELECT DISTINCTROW Payments.MemberID, SUM(Payments.PaymentAmount) AS TotalPayments
41                           FROM Payments GROUP BY Payments.MemberID ";
42 
43  // Get Invoice for member
44  $getmembercommittee = "SELECT * FROM Payments";
45 
46 
47 
48  $result=mysql_query($getmembercommittee);
49  if(!$result) {
50     print "ERROR MySQL SAID: " . mysql_error();
51     print "<P>" . $getpaymentsum;
52  } else {
53    print "<table><tr>\n";
54          while($field=mysql_fetch_field($result)) {
55           print "<th>".$field->name."</th>\n";
56           }
57          print "</tr>";
58          while($value=mysql_fetch_array($result)) {
59           print "<tr bgcolor=#CCCCCC>\n";
60           for($i=0; $i < mysql_num_fields($result); $i++) {
61                  print "<td>".$value[$i]."</td>\n";
62           }
63           print "</tr>\n";
64          }
65    print "</table>\n";
66  }
67 
68  ?>