<?php
    
include("../include/FunctionDB.php");
    
ConnectDB();        
    
$Year_start $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];
    
$Year_finish $_POST[mYear2]."-".$_POST[mMonth2]."-".$_POST[mDate2];
    
$strSQL="UPDATE research_tb SET Teacher_code='$Teacher_code',Branch='$Branch',Research_name='$Research_name',Research_type='$Research_type',Research_char='$Research_char',R_position='$R_position',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',name8='$name8',Year_start='$Year_start',Year_finish='$Year_finish',Fund='$Fund',Fund_resource='$Fund_resource',Resource_des='$Resource_des',Propagate='$Propagate',Propagate_des='$Propagate_des',Prop_type='$Prop_type',Prop_type1='$Prop_type1',Prop_type2='$Prop_type2',Prop_type3='$Prop_type3',Apply1='$Apply1',Apply2='$Apply2',Apply3='$Apply3',Year_prop='$Year_prop' WHERE Research_code='$Research_code'";
    
$result  mysql_query($strSQL) or die("Update Error $strSQL".mysql_error());
    
  echo
"<center><font face=\"Tahoma\"size=\"6\" color=\"#FF0000\">Update Complete</font></center>";
 echo
"<meta http-equiv=\"refresh\" content=\"1;URL=EditResearchList.php?Teacher_code=$Teacher_code\">";
//    header("Location:EditResearchList.php?Teacher_code=$Teacher_code");                
        
CloseDB();
?>