<?php
    include("../include/FunctionDB.php");
    ConnectDB();  
   $DateBirth = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];
       $Path = "../personal_pic"; 
    if ( isset($Img1) )
    if (copy($Img1,"$Path/$Img1_name")) 
       {
            unlink ($Img1);
            $Img1 = "$Path/$Img1_name";
         }
        else
            echo"Can't Copy";
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      if($Img1){                                                 
        $strSQL="UPDATE personal_tb SET First_name='$First_name',Teacher_name='$Teacher_name',Teacher_lastname='$Teacher_lastname',DateBirth='$DateBirth',Sex='$Sex',Nationality='$Nationality',Nation='$Nation',Religion='$Religion',Citizen_id='$Citizen_id',Father_name='$Father_name',Mother_name='$Mother_name',Status='$Status',Status2='$Status2',Status3='$Status3',Soulmate='$Soulmate',Total_child='$Total_child',Address='$Address',Img1='$Img1'  WHERE Teacher_code='$Teacher_code'";
   }
   else{                                                 
        $strSQL="UPDATE personal_tb SET First_name='$First_name',Teacher_name='$Teacher_name',Teacher_lastname='$Teacher_lastname',DateBirth='$DateBirth',Sex='$Sex',Nationality='$Nationality',Nation='$Nation',Religion='$Religion',Citizen_id='$Citizen_id',Father_name='$Father_name',Mother_name='$Mother_name',Status='$Status',Status2='$Status2',Status3='$Status3',Soulmate='$Soulmate',Total_child='$Total_child',Address='$Address' WHERE Teacher_code='$Teacher_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=Show_Fam_History.php?Teacher_code=$Teacher_code\">";        
//    header("Location:Show_Fam_History.php");    
     CloseDB();
?>