<?php  include("../../include/dbconnect.php");?>
<?
if ( isset($submit) && $submit == "submit")
{
$quot_refdt = substr($sdt,6,4).'/'.substr($sdt,3,2).'/'.substr($sdt,0,2);
$yr_refdt = substr($ydt,6,4).'/'.substr($ydt,3,2).'/'.substr($ydt,0,2);

//echo "rec" . "$record";
//echo "for enquiry, cost sheet and quotatino";

$query = "update quotation set bcode='$bcode', quot_refno='$quot_refno', quot_refdt='$quot_refdt', attn='$attn', yr_refno='$yr_refno', yr_refdt='$yr_refdt', enquiry_refno='$enqrefno',  enquiry_refdt='$enqrefdt', prodcode='$prodcode', drawing_no='$drawing_no', prodname='$prodname', rawoffer='$rawoffer', rawwgt='$rawwgt', rawrate='$rawrate', rawcost='$rawcost', invper='$invper', invcost='$invcost', processcost='$processcost', admnexp='$admnexp', scrapcost='$scrapcost',  tlcost='$tlcost', delperiod='$delperiod', st='$st', exduty='$exduty', pandf='$pandf', payterms='$payterms',  price='$price', subtot='$subtot', tot='$tot' where record='$rec'";


//echo "$query";	
mysql_query($query) or die (mysql_error());

}
?>
<meta http-equiv="refresh" content="0 url=index.html">
</body>





