<?php 
include("../../include/dbconnect.php");
?>
<title> Party Ledger details edit</title>
<body bgcolor="#ffffff"  topmargin=0>
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font ><b>Party Ledger  details edit</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="form1" method="POST"  action="update3.php?record=<?echo($record);?>">
<?php 

$result=mysql_query("select distinct record,invno,date,prodcode,qty,rate,dbamt,narration,compcode,paystatus from tledger where record = '$record' ");
$row1=mysql_fetch_row($result);
?>

<table border="0" cellspacing="1" cellpadding="4" align="center" width="500" bgcolor="#999999">
        

<input type="hidden" name="record" value="<? echo($row1[0]); ?>">

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Inv No </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="billno" value = <?php echo("'$row1[1]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Date </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="date" value = <?php echo("'$row1[2]'");?>>  </td></tr>

<tr><td bgcolor="#FFFFFF"><font class="sbd"><b>Product Code </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=8 size="10" readonly name="prodcode" value = <?php echo("'$row1[3]'");?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Qty</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="qty" value = <?php echo("'$row1[4]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Rate  </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=8 size="10" name="rate" value = <?php echo($row1[5]);?>></td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>DB Amount </b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="amount" value = <?php echo("'$row1[6]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Narration</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="narration" value = <?php echo("'$row1[7]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Compcode</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="compcode" value = <?php echo("'$row1[8]'");?>>  </td></tr>

<tr><td  bgcolor="#FFFFFF"><font class="sbd"><b>Payment Status</b></font></td><td  bgcolor="#FFFFFF">
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="paystatus" value = <?php echo("'$row1[9]'");?>>  </td></tr>

<tr>
<td align=right>
 <blockquote>  <input  type =submit name=submit value = "Update"></td> <td><input type =submit name=submit value = "Delete"></blockquote>
</table>

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