$SumPrice2=($SumOt+$SumPrice);
$SumPrice3=$_POST['SumPrice2'][$i];
$Rg25=$SumPrice2;//เก็บค่้าวตัวแปรเพื่อใช้ในการเปรียบเที่ยบค่าข้มูล
$Honda=$SumPrice2;
$Seed=$SumPrice2;
$Project_bud=$_POST['Project_bud'][$i];
echo"$Project_bud/";
if($Project_bud=='RG25'){
$updateStr1=mysql_query("UPDATE $tb SET Rg25='$Rg25' WHERE CustomerID='$CustomerID' and month2='$month2'");
echo"$updateStr1";
}
if($Project_bud=='HONDA'){
$updateStr2=mysql_query("UPDATE $tb SET Honda='$Honda' WHERE CustomerID='$CustomerID' and month2='$month2'");
echo"$updateStr2";
}
if($Project_bud=='Seed'){
$updateStr3=mysql_query("UPDATE $tb SET Seed='$Seed' WHERE CustomerID='$CustomerID' and month2='$month2' ");
echo"$updateStr3";
}
$SumPrice3=$SumPrice2;
{
$sql="UPDATE $tb SET Sumdate='$Sumdate',SumPrice='$SumPrice',SumOt='$SumOt',SumPrice2='$SumPrice2',SumPrice3='$SumPrice3' WHERE CustomerID='$CustomerID' and month2='$month2' "or die("ไม่สามารถบันทึกได้");
mysql_query($sql);
}
}
echo"[บันทึกเรียบร้อยแล้ว]";
?>
<a href="uuu_2.php">กลับ</a>
041001/0/Seed/UPDATE month SET Seed='510' WHERE CustomerID='1001' and month2='04' 1002/0/Seed/UPDATE month SET Seed='510' WHERE CustomerID='1002' and month2='04' 1003/0/Seed/UPDATE month SET Seed='510' WHERE CustomerID='1003' and month2='04' 1004/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1004' and month2='04'1005/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1005' and month2='04'1006/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1006' and month2='04'1007/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1007' and month2='04'1008/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1008' and month2='04'1009/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1009' and month2='04'1010/0/HONDA/UPDATE month SET Honda='510' WHERE CustomerID='1010' and month2='04'1011/0/RG25/UPDATE month SET Rg25='510' WHERE CustomerID='1011' and month2='04'1012/0/RG25/UPDATE month SET Rg25='510' WHERE CustomerID='1012' and month2='04'1013/0/RG25/UPDATE month SET Rg25='510' WHERE CustomerID='1013' and month2='04'1014/0/RG25/UPDATE month SET Rg25='425' WHERE CustomerID='1014' and month2='04'1015/0/RG25/UPDATE month SET Rg25='540' WHERE CustomerID='1015' and month2='04'1016/0/RG25/UPDATE month SET Rg25='525' WHERE CustomerID='1016' and month2='04'1017/0/RG25/UPDATE month SET Rg25='525' WHERE CustomerID='1017' and month2='04'1018/0/RG25/UPDATE month SET Rg25='540' WHERE CustomerID='1018' and month2='04'1019/0/RG25/UPDATE month SET Rg25='540' WHERE CustomerID='1019' and month2='04'[บันทึกเรียบร้อยแล้ว]กลับ
นี่คือสิ่งที่แสดงครับ รบกวนด้วยหน่อยนะครับ