<?php
include ("../include/session.php");
if (!$session->logged_in) {
	header("Location: ../../main.php");
} else {
	include ("../header.php");
//	include ("../include/db.php");
	}

	
	
	$query = "SELECT empID, empFName, empLName, empIDNo, empBank, empBranch, EmpAccNo FROM employees ORDER BY empLName Asc";
	$result = mySQL_query($query) or die ("Error in query:   $Query . * ". mySQL_error());
	$i = 0;
	$num = mysql_num_rows($result);
	
	
	
?>
<link href="../css/styles.css" rel="stylesheet" type="text/css" />
<link href="../css/all.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style6 {font-size: small;
	font-family: Arial, Helvetica, sans-serif;
}
.style9 {font-size: small}
.style10 {font-size: x-small}
-->
</style>
<div class="headerbox">Employees banking</div> 
<div class="menubox"> <div align="right"><a href="employeeList.php"><img src="../../Images/Employee list_btn.png" alt="." width="110" height="25" border="0" /></a></div>
      <div align="right"><span class="style6"><a href="employeeSizeList.php"><img src="../../Images/Size_list_btn.png" alt="." width="110" height="25" border="0" /></a><a href="employeeBankList.php"></a></span></div>
      <div align="right"><a href="employeeRate.php"><span class="style6">
          
        </span></a><a href="employeeRate.php"><img src="../../Images/Rates_list_btn.png" alt="." width="110" height="25" border="0" /></a></div>
      <div align="right"><a href="searchAndDisplay.php"><img src="../../Images/employees_back_btn.png" alt="." width="110" height="25" border="0" /></a>
        <input name="image" type ="image" onclick="JavaScript:printPreviewDiv('top-bar');" src="../../Images/print_btn.png" alt="Click  to print" align="right" width="75" height="25" border ="0" />
      </a></div>  
</div>
    <div class="subheaderbox">
      Employee bank list  as per : <?php echo date("d-m-Y");?>
    <span class="style9"><br />
    Number in list:<?php echo $num;?></span>    </div> <br /><br /><br /><br />

<p>&nbsp;</p>
<table id="test1" cellpadding="0" cellspacing="0" border="0"
	class="rowstyle-alt colstyle-alt no-arrow">
	<thead>
		<tr>
			<th width="167" class="sortable-text">Name, First Name</th>
			<th width="73" class="sortable-numeric">ID Number</th>
			<th width="56" class="sortable-text">Bank</th>
			<th width="75" class="sortable-text">Branch</th>
			<th width="108" class="sortable-numeric">Account No</th>
		</tr>
	</thead>
	<tbody>
	<?php 
	while ($i < $num) {
	    $b0 = mysql_result($result, $i, "empID");
		$b1 = mysql_result($result, $i, "empLName");
	    $b2 = mysql_result($result, $i, "empFName");
	    $b3 = mysql_result($result, $i, "empIDNo");
	    $b4 = mysql_result($result, $i, "empBank");
		$b5 = mysql_result($result, $i, "empBranch");
		$b6 = mysql_result($result, $i, "empAccNo");
	?>
	
	<tr class="alt">
		<td><a href="searchAndDisplayE.php?id=<?php echo $b0?>">  <?php echo $b1. ", " .$b2 ?></td>
		<td><?php echo $b3 ?></td>
		<td><?php echo $b4 ?></td>
		<td><?php echo $b5 ?></td>
		<td><?php echo $b6 ?></td>
	</tr>
	<?php 
	$i++;
	}
	?>
	
	</tbody>
	
</table>

	<?php
	include("../footer.php");

?>


