<?php 

session_start(); 

$message = $_GET['message'];



if (!$_SESSION['unamename']) { 

    $error = "You are not logged in!"; 

	header("Location:../login.php?message=$error");

    exit(); 

} 

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<html lang="en">



<head>

<title>Administrator's Control Panel - Display Available Accounts</title>

<meta name="GENERATOR" content="Microsoft FrontPage 6.0">

<meta name="CODE_LANGUAGE" content="C#">

<meta name="vs_defaultClientScript" content="JavaScript">

<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">

<script type="text/javascript" SRC="../../../includes/scripts/script.js" type="text/javascript"></script>

<meta http-equiv="Content-Style-Type" content="text/css">

<link rel="stylesheet" type="text/css" media="aural" href="../../includes/css/DPC_auralstyle.css">

<link rel="stylesheet" type="text/css" media="print" href="../../includes/css/DPC_printstyle.css">

<link rel="stylesheet" type="text/css" media="screen" href="../../includes/css/FA_style.css">

<script type="text/javascript" type="text/javascript" SRC="../js/common.js"></script>

<style type="text/css">

<!--

.style4 {font-size: x-small; color: #000000; }

-->

</style>

<noscript></noscript>

</head>

<body topmargin="0"leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" ms_positioning="FlowLayout">



<table border="0" cellpadding="0" cellspacing="0" class="wrapperTable" width="100%">

	<tr>

		<td class="headerCell" valign="top" colspan="2">

		<div class="ddalink">

			<a accesskey="m" title="Skip to menu" class="ddalink" href="#menu">Skip 

			to menu </a>

			<a accesskey="c" title="Skip to content" class="ddalink" href="#content">

			Skip to content </a>

			<a id="AccessLink" accesskey="o" title="Turn on Accessibility Features " class="ddalink" href="#">

			Turn on Accessibility Features</a> </div>

		



<a name="top"></a>

<table class="header" border="0" cellpadding="0" cellspacing="0" width="100%">

	<tr>

		<td valign="bottom">

		<a accesskey="h" HREF="../../default.php">

		 <img src="../../images/logo.png" width="200" height="120" alt="" border="0"></a></td>

		<!--td width="100%" valign="top"><a href="#content" accesskey="s"></a>

		<img border="0" src="/microsites/online_/images/spacer.gif" alt=" " width="1" height="60"></td-->

		<td valign="top">

		<img src="../../images/topcontainerbg.gif" width="1140" height="120" alt="" border="0"></td>

	</tr>

</table>
<hr color="#003da6">





<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">

  <tr>

  		<td class="option-bar-shadow-home" valign="top"><img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="4"></td>

  </tr>

</table><br />

		<table cellspacing="0" cellpadding="0" border="0" width="100%" id="table3" class="intropara"><!-- Inline CSS Whole Table -->

			<tr>

				<td rowspan="98" valign="top" width="10" bgcolor="#ffffff">

				</td>

				<td valign="top" width="11">

				<img SRC="../../images/intro/tl.gif" width="7" height="6" alt=" " border="0"></td>

				<td rowspan="2">

				<strong>Welcome</strong><span class="detailValueGeneral"><strong> <?php echo $_SESSION['name']; ?></strong></span><br />

			  </td>

				<td rowspan="2" valign="top" align="right">

				<img SRC="../../images/intro/tr.gif" width="8" height="7" alt=" " border="0"></td>

				<td bgcolor="#ffffff" rowspan="2"></td>

			</tr>

			<tr>

				<td valign="top"></td>

			</tr>

			<tr>

				<td height="11" colspan="4" bgcolor="#ffffff"></td>

			</tr>

		</table>

		</td>

	</tr>

	<tr>

		<td height="295" valign="top" class="menuCell"><a id="menu" name="menu"></a>

		<table cellpadding="2" cellspacing="0" width="148">

			<tr>

				<td>

				<table width="85%" border="0" cellpadding="0" cellspacing="0" class="mnu" style="width:100%;border-collapse:collapse;">

                  <tr class="mnu0">

                    <td colspan="2"><a accesskey="2" title="Access Key = 2" class="mnu0" href="../index.php"> Home </a></td>

                  </tr>

                  <tr class="mnu0">

                    <td colspan="2"><a accesskey="1" title="Access Key = 1" class="mnu0" HREF="../accounts/index.php">Accounts</a></td>

                  </tr>

                  <tr class="mnu0open">

                    <td class="mnu0a">&nbsp;</td>

                    <td><a accesskey="3" title="Access Key = 3" class="mnu0open" HREF="index.php"> <span>Transactions</span></a></td>

                  </tr>

                  <tr class="mnu1current">

                    <td class="mnu1a">&nbsp;</td>

                    <td>Display Transactions </td>

                  </tr>

                  <tr class="mnu1">

                    <td class="mnu1a">&nbsp;</td>

                    <td><a class="mnu1" HREF="delete.php"><span>Delete Transactions </span></a></td>

                  </tr>

                  <tr class="mnu0">

                    <td colspan="2"><a accesskey="6" title="Access Key = 6" class="mnu0" href="../settings/index.php"> <span>Change Settings</span></a></td>

                  </tr>

                  <tr class="mnu0">

                    <td colspan="2"><a accesskey="7" title="Access Key = 7" class="mnu0" href="../logout.php"> <span>Leave</span></a></td>

                  </tr>

                </table>

				<!--br>

<div class="altframe" style="width:148px;margin-right:0px;padding-right:0px;">

	<b>

	<h3><span id="ASBTHE" class="fauxh3">Apply Online</span></h3>

	</b>

	<table class="olalt-panel" border="0" padding="0">

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01a.php?id=PERSONAL/LOANS/PERSONAL_LOAN">

			Apply for a loan</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/SAVINGS_INVESTMENTS">

			Apply for a savings account</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/CREDIT_CARDS">

			Apply for a credit card</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/MORTGAGES">Apply 

			for a mortgage</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/CURRENT_ACCOUNTS">

			Apply for a current account</a></td>

		</tr>

	</table>

</div-->

</td>

			</tr>

		</table>

	  </td>

 <?php

include("../../base.php");

$query="SELECT * FROM mayis";

$result=mysql_query($query);



$total=mysql_numrows($result);



mysql_close();



?>	       

		<td style="width:100%" class="contentCell" valign="Top">

			<h1 id="AS1BTHA">Display Available Accounts </h1>

		  <div id="AS1SIT1A" class="frame">

				<h2 id="AS1BTHB">Below are customer account details in the database</h2>

				<p><span id="AS1BTEA" class="clearImg">Total Number of Accounts in the database is <strong><?php echo $total; ?></strong></span></p>

		  </div>

			<div id="AS1SIT2A" class="frame">		    

			  <table id="MiniStatementNAP" cellpadding="4" cellspacing="0" class="ItemTable">

                <colgroup>

                <col class="Date" />

                <col class="Wrap" />

                <col class="Currency" />

                <col class="Currency" />

                </colgroup>

                <thead>

                  <tr class="ItemTable">

                    <th width="9%" scope="col" abbr="Date"> <div align="left" class="style4">

                      <div align="left"><a class="dtHdrOn" title="Order by Date descending" href="#"> Transaction No</a></div>

                    </div></th>

                    <th width="6%" scope="col" abbr="Date"><div align="left"><a href="#" title="Order by Date descending" class="dtHdrOn hdr style4">client No</a></div></th>

                    <th width="13%" scope="col" abbr="Description"> <div align="left" class="style4">

                      <div align="left"><a class="dtHdr" title="Order by Description" href="#"> Date </a></div>

                    </div></th>

                    <th width="11%" scope="col" abbr="In"> <div align="left" class="style4">

                      <div align="left">Transaction Details </div>

                    </div></th>

                    <th width="3%" scope="col" abbr="In"><div align="left"><span class="style4">Description</span></div></th>

                    <th width="7%" scope="col" abbr="In"><div align="left"><span class="style4">Paid In </span></div></th>

                    <th width="12%" scope="col" abbr="Out"> <div align="left" class="style4">

                      <div align="left">Paid Out </div>

                    </div></th>

                    <th width="4%" scope="col" abbr="Out"><div align="left"><span class="style4">Transaction Status </span></div></th>

                  </tr>

                </thead>

           <?php

include("../../base.php");

$query="SELECT * FROM account";

$result=mysql_query($query);



$num=mysql_numrows($result);



mysql_close();

$i=0;

while ($i < $num) {



$trans_no=mysql_result($result,$i,"trans_no");

$client_no=mysql_result($result,$i,"client_no");

$date=mysql_result($result,$i,"date");

$trans_details=mysql_result($result,$i,"trans_details");

$description=mysql_result($result,$i,"description");

$paid_in=mysql_result($result,$i,"paid_in");

$paid_out=mysql_result($result,$i,"paid_out");

$trans_status=mysql_result($result,$i,"trans_status");



?>

                <tr class="dto">

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"><?php echo $trans_no; ?></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $client_no; ?></span></div></td>

                  <td><div align="left" class="hdr hdr"><?php echo $date; ?></div></td>

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"> <?php echo $trans_details; ?> </div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $description; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $paid_in; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"> <?php echo $paid_out; ?> </div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $trans_status; ?></span></div></td>

                </tr>

                <?php

$i++;

}



?>

              </table>

			</div>

		</td>

	</tr>

	<tr>

		<td colspan="2">

		



<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">

	<tr>

		<td>

		<img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="5"></td>

	</tr>

	<tr>

		<td valign="top">

		<img border="0" SRC="../../images/footer/left_botcorner.gif" alt=" " align="left" hspace="0" width="10" height="23"></td>

		<td width="100%" class="bgcolor-footer" valign="top">

		<script type="text/javascript" SRC="../../../includes/scripts/redsheriff.js" type="text/javascript"></script>

		<noscript>

		<img SRC="C|/wamp/nielsen.natwest.com/cgi-bin/count@cid=ulster Bank" alt=" " width="1" height="1">

		</noscript>

		<img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="5"></td>

		<td valign="top">

		<img border="0" SRC="../../images/footer/right_botcorner.gif" align="right" alt=" " hspace="0" width="10" height="23"></td>

	</tr>

</table>

</td>

	</tr>

</table>



</body>



</html>
