<body background="i.jpg">
<?php include("../../include/dbconnect.php");


// Get all _POST VALUES HERE..



$result = mysql_query("select account_year from company") or die(mysql_error());
$row = mysql_fetch_row($result);
$account_year = $row[0];
?>
<title>Cancel Invoices</title>
<body background=blater01.gif  topmargin=0>
<center> 
<table cellpadding=0 cellspacing=4 width=590>
  <tr> 
    <td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font face="Verdana, Arial, Helvetica, sans-serif"><b><b>Cancel Invoices</b></font></td>
  </tr>
  <tr valign="top"> 
    <td colspan=2> <font >&nbsp;</font> </td>
  </tr>
</table>
<table border=0 cellpadding=3 cellspacing=4 width="590">




<form name='myForm02' method='POST' action='labour_cancel_entry.php' >
<tr> 
<td width="139" height="31" align="right" ><font color="#003366" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>Category
  &nbsp;</b></font></td><td>

<?  
$result= mysql_query(" select distinct invdate,invno,bcode from labourinv where account_year = '$account_year' ")or die( mysql_error() );
 ?>
  <SELECT name='invnos' >
    <?
echo "<option selected value=\" 0\"> Select Invoice";
while($row = mysql_fetch_row($result))
{
	$bres = mysql_query("select name from buy where bcode = '$row[2]' ") or die(mysql_error());
	$brow = mysql_fetch_row($bres);
	
	$temp = british($row[0]).','.$row[1].'('.$brow[0].')';

		echo "<option value=\"$row[1]\">$temp";
}
?>
  </SELECT></td></tr>  
  </table>
  
  <table cellpading=0 cellspacing=10 width= 50>
    <tr> 
      <td> <blockquote> <input type =submit name="submit" value = "Submit"></blockquote></td>
  </table>
</table>


                                                                             
</body></form>
<br><br><font size=1><center><a href= "../../index.html">Return to index page</a></center></font>
