<?php
 session_start();
 if (session_is_registered("valid_user"))
 {
include("../include/FunctionDB.php");
ConnectDB();
$Date_start = $_POST['mYear1']."-".$_POST['mMonth1']."-".$_POST['mDate1'];
$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',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',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());

  echo"<center><font face=\"Tahoma\"size=\"6\" color=\"#FF0000\">Update Complete</font></center>";
 echo"<meta http-equiv=\"refresh\" content=\"1;URL=FrmProductList.php\">";
    
CloseDB();
?>
<?php 
    }
else
{
       echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
       echo"Please Login ";
}
?>