<?php
    include("../include/FunctionDB.php");
    include("../include/Function.php");
    ConnectDB();
$Date = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];                    
$Date_start = $_POST[mYear1]."-".$_POST[mMonth1]."-".$_POST[mDate1];
$Date_finish = $_POST[mYear2]."-".$_POST[mMonth2]."-".$_POST[mDate2];                                                                                                                                                                                                                                                                                                                                                                                                      
       $strSQL="UPDATE   training_tb  SET     Teacher_code='$Teacher_code',Training_name='$Training_name',Training_type='$Training_type',Year_std='$Year_std',Date_start='$Date_start',Date_finish='$Date_finish'   Where   Training_code='$Training_code'  "; 
        $result  = mysql_query($strSQL) or die("Update Error $strSQL $result".mysql_error());
         $strSQL1 = " UPDATE   FormAoffice  SET          Teacher_code='$Teacher_code',code='$code',ProjectId='$ProjectId',No_in='$No_in',Detail='$Detail',Date='$Date',Date_start='$Date_start',Date_finish='$Date_finish',Training_name='$Training_name',Training_type='$Training_type',Day='$Day',Year_std='$Year_std',TeacherId='$TeacherId',Flag1='$Flag1',Flag2='$Flag2'   Where  Training_code='$Training_code'  ";
    $result1  = mysql_query($strSQL1) or die("Update Error $strSQL $result1".mysql_error());
        $strSQL1  =  " UPDATE   project_tb    SET    ProjectId='$ProjectId',Training_name='$Training_name',Orderlist='$Orderlist',Project_plan='$Project_plan',MoneyS_C='$MoneyS_C',MoneyId='$MoneyId',Date='$Date',Budget_use='$Budget_use' Where  Training_code='$Training_code'   and  Teacher_code='$Teacher_code' ";
         $result1  = mysql_query($strSQL1) or die("Update Error $strSQL $result1".mysql_error());
    echo "<center>";
    echo"<font face=\"Ms san serif\"size=\"4\"><font color=\"0000FF\">$Fname</font>Edit Complete </font></center>";
    echo"<meta http-equiv=\"refresh\" content=\"1;URL=FormAList.php?Teacher_code=$Teacher_code\">";         
   CloseDB();
?>