$costTmp2) $costSumTmp = ($rss['Cost1']+$rss['Cost5']) - ($rss['CostSum']+$rss['Cost2']+$rss['Cost3']+$rss['Cost4']);
else $costSumTmp = ($rss['CostSum']+$rss['Cost2']+$rss['Cost3']+$rss['Cost4']) - ($rss['Cost1']+$rss['Cost5']);
/***************************************************************************************************************/
// =================== update ข้อมูลของ record นี้ =============================
$costSumTmp2 = ($Cost1+$Cost5+$costSumTmp)-($Cost2+$Cost3+$Cost4);
$dateNote = dmyE2ymdT($date);
$sql = " UPDATE state_tb SET Year_State='$Year_State',Date_note='$dateNote',No='$No',Disciption='$Disciption',Cost1='$Cost1',Cost2='$Cost2',Cost3='$Cost3',Cost4='$Cost4',Cost5='$Cost5',CostSum='$costSumTmp2' WHERE stateId ='$stateId' ";
$result = mysql_query($sql) or die("Update Error $sql".mysql_error());
//===================================================
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//select ข้อมูล ที่อยู่ต่อจาก record นี้ทั้งหมด เพื่อทำการ update ยอดรวมทั้งหมดอีกครั้ง
$sql3 = "select * from state_tb where stateId > '$stateId' AND State = '$rss[State]' ";
$result3= mysql_query($sql3) or die("Select State Error $sql2".mysql_error());
if($result3){
$i = 0;
$costSumTmp4;
while($rss2 = mysql_fetch_array($result3)){
if($i == 0) $costSumTmp3 = ($rss2['Cost1']+$rss2['Cost5']+$costSumTmp2) - ($rss2['Cost2']+$rss2['Cost3']+$rss2['Cost4']);
else {
//$costTmp3 = $rss2['Cost1'] + $rss2['Cost5'];
//$costTmp4 = $rss2['CostSum'] + $rss2['Cost2'] + $rss2['Cost3'] + $rss2['Cost4'];
//if($costTmp3 > $costTmp4) $costSumTmp4 = ($rss2['Cost1']+$rss2['Cost5']) - ($rss2['CostSum']+$rss2['Cost2']+$rss2['Cost3']+$rss2['Cost4']);
//else $costSumTmp4= ($rss2['CostSum']+$rss2['Cost2']+$rss2['Cost3']+$rss2['Cost4']) - ($rss2['Cost1']+$rss2['Cost5']);
$costSumTmp3 = ($rss2['Cost1']+$rss2['Cost5']+$costSumTmp4) - ($rss2['Cost2']+$rss2['Cost3']+$rss2['Cost4']);
}
$costSumTmp4 = $costSumTmp3;
$sql4 = "UPDATE state_tb SET CostSum='$costSumTmp3' WHERE stateId ='$rss2[stateId]'";
$result4 = mysql_query($sql4) or die("Update Error $sql4".mysql_error());
$i++;
}
}
//=======================================================
if ($result || $result3){
//header("Location:EditStateList.php?State=$State");
echo"";
echo"
แก้ไขข้อมูลเรียบร้อยแล้ว";
}
CloseDB();
?>
\n";
echo"Please Login ";
}
?>