require('dbcon.php');
///////////sc item update
$scno=$_POST['scno'];
$seqno=$_POST['seqno'];
$qty=$_POST['qty'];
///////sc item update
$sqlupdatescitem=mysql_query("UPDATE SC_Item SET Quantity='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
//////pc item update
$sqlupdatepcitem=mysql_query("UPDATE PC_Item SET Quantity='$qty' WHERE SC_No='$scno' AND Seq_No='$seqno'");
////ibws_data update
$sqlupdateibwsdataitem=mysql_query("UPDATE Ibws_Data SET order_qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
////////sc_ini item
$sqlupdateiniitem=mysql_query("UPDATE Sc_Itemnot_Include SET Ord_Qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
///////
/////ST History
$sqlupdatesthistory=mysql_query("UPDATE ST_History SET Qty='$qty' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
////
////pc dlvy head
$sqlupdatepcdlvyhead=mysql_query("UPDATE PC_Dlvy_Head SET Qty='$qty',Dlvy1_Qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno' ");
?>
Home