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 MEMBERSHIP");
12 
13  bodyTag();
14 
15  // Define $conn
16  $conn = connect();
17 
18 
19  // if this is a submit process
20    $select_qry = "SELECT * from Members";
21       
22    $result = query($select_qry);
23    if(!$result) {
24          print error();
25          } else {
26          print "Data returned!!!";
27          print "<TABLE>";
28          while($row=fetch_array($result)) {
29           extract($row);
30           print "<tr><td>". $MemberID . "</td><td>" . $FirstName
31  . "</td><td>" . $LastName . "</td><td>" . $EmailName
32  . "</td></tr>";
33          }
34          print "</TABLE>";
35    }
36 
37 
38  // print "Committees Script";
39 
40 
41 
42 
43  pageBottom();
44  siteFooter();
45 
46  ?>