<?php
include("../include/FunctionDB.php");
ConnectDB();
$Teacher_code = $_POST[Teacher_code];
$Date_start  = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];
$Date_finish = $_POST[mYear2]."-".$_POST[mMonth2]."-".$_POST[mDate2];

$sql = " UPDATE edu_product_tb SET Product_name='$Product_name',Date_start='$Date_start',Date_finish='$Date_finish',Term='$Term',Product_type='$Product_type',Fund_resource='$Fund_resource',Fund='$Fund',Propagate='$Propagate',Benefit='$Benefit',Use_ref='$Use_ref' WHERE Prod_code ='$Prod_code' ";
$result = mysql_query($sql) or die("Update Error $sql".mysql_error());
header("Location:EditProductList.php?Teacher_code=$Teacher_code");            
CloseDB();
?>