<?php
// Include variables and functions
require('appinclude.php');
siteHeader("Web Technology SIG");
// Create an array for the navBar() function
$link_array = array (
"Main" => "index.php",
"List All" =>"list.php"
);
// Create an array for the status options
$status_str = array(
" => ",
"closed" => "CLOSED"
);
// Create a page break <P>
printPage();
// Create template using pageTop() function
pageTop("Demo WorkOrder System: ADD WorkOrder...");
// If this is a form submit process the data sent via post
if($submit) {
// Check to see if certian values where entered...
if((!$wkorder_id) || (!$problem_descrp)) {
print
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 ?>
|