<?php 
ob_start();
$PageSecurity = 2;
include('includes/session.inc');
$title = _('Material Receipt Note');
include('includes/header.inc');
?>
<br /><br />
<table width="100%" border="0">

<tr>
    <td colspan="6"> <strong>BILL BOOK</strong></td>
  </tr>
  
  <tr  >
    <th width="9%"><strong>MRN No</strong></th>
    <th width="24%"><strong>Site</strong></th>
    <th width="14%"><strong>Store</strong></th>
    <th width="18%"><strong>Vendor</strong></th>  
    <th width="22%"><strong>Bill Date</strong></th>
    <th width="13%"><strong>View</strong></th>
  </tr>
  
  <?php
  $sql = "select * from  purchase_billbook ";
	$result=DB_query($sql, $db);
	$i=0;
  while($myrow=DB_fetch_array($result))
  {  
     if($i++%2==0)
	 $bgcolor="#CCCCCC";
	 else
	 $bgcolor="#FFFFFF";
  ?>
   <tr bgcolor="<?php  echo $bgcolor ?>"  valign="middle" >
    <td><div align="center"><?php echo $myrow['mrn_no']?></div></td>
    <td><?php echo $myrow['site']?></td>
    <td><?php echo $myrow['store']?></td>
     <td><?php echo $myrow['vendor']?></td>   
	 <td><?php echo $myrow['bill_date']?></td>
	<td><div align="center"><a href="view_purchBillBook.php?mrn=<?php echo $myrow['mrn_no'];?>"> <img src="images/search.gif" width="10" height="10" /></a></div></td>
  </tr>
  <?php }
  ?>
</table>
