Location: PHPKode > projects > Gsys > treasury/one_user_transactions.php
<?PHP
//Filename : one_user_transactions.php
//Description : View individual user transactions
//Author :  darc
//Last modified :  2006.12.20

    include '../includes/auth_ec.php';
    include '../includes/db.php';
?>
<html>
<head><title>Gsys :: Individual User Transactions</title>
<link href="../includes/index.css" rel="stylesheet" type="text/css">
</head>

<body class="body">
<br />
<table width="810" height="626" border="0" align="center" cellpadding="15">
  <tr> 
    <td height="128" colspan="2"><img src="../images/eg_banner.gif" width="810" height="172"></td>
  </tr>
  <tr> 
    <td width="27%" height="488" valign="top"> <?php include '../includes/nav.inc'; ?></td>
    <td width="53%">
<strong>View a specific members transactions:</strong>
<br /><br />
<form method="post" action="treasury_functions.php?cat=user_transaction_list">


<strong>Member Name:</strong><SELECT NAME="member_pin">
<OPTION VALUE="">

<?php  //populate list with active users
        $sql = "SELECT pin_num, l_name, f_name, status FROM brothers WHERE l_name != \"\" && status != \"alumnus\" ORDER BY l_name;";
         $result = mysql_query($sql,$connection) or die(mysql_error);
         while($row =mysql_fetch_array($result))
		{
			$l_name = $row['l_name'];
			$f_name = $row['f_name'];
			$pin_num_tmp = $row['pin_num'];
			echo "<OPTION VALUE=\"$pin_num_tmp\">$l_name, $f_name";
		}
?>
</SELECT>
<br /><br />
<INPUT TYPE="SUBMIT" NAME="submit" VALUE="Show Transactions">
</form>
   </td>
  </tr>
</table>
</body>
</html>
Return current item: Gsys