<?php 
include("../../include/dbconnect.php");
?>
<title> Product details edit</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 ><b>Product 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="update.php?<?echo($record);?>">

<? 	

$result=mysql_query("select * from product where record = '$record' ");
$row1=mysql_fetch_row($result);
?>

<tr><td><font class="sbd"><b>Customer Code </b></font></td><td>
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=11 size="12" name="bcode" value = <?php echo($row1[0]);?>></td></tr>

<tr><td><font class="sbd"><b>Product Code </b></font></td><td>
<input type="text"    onKeyPress="return event.keyCode!=13"   maxlength=14 size="15" name="prodcode" value = <?php echo($row1[1]);?>></td></tr>

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

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

<tr><td><font class="sbd"><b>Labour Rate</b></font></td><td>
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="labour_rate" value = <?php echo("'$row1[14]'");?>>  </td></tr>

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

<tr><td><font class="sbd"><b>Customers Product Code</b></font></td><td>
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="cust_prodcode" value = <?php echo("'$row1[5]'");?>>  </td></tr>

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

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

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

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

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

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

<tr><td><font class="sbd"><b>Finish Type</b></font></td><td>
<input type="text"    onKeyPress="return event.keyCode!=13"   size="40" name="finish" value = <?php echo("'$row1[12]'");?>>  </td></tr>


<input type="hidden" name="record" value="<?echo $record;?>">

<table cellpading=0 cellspacing=10 width= 50>
<tr>
<td>
 <blockquote>  <input type =submit name=submit value = "Update"></td> <td><input type ="submit" name="submit" value = "Delete"></blockquote>
</table>

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