<?php
session_start();

 if (session_is_registered("valid_user")&&session_is_registered("Priority"))
 {
 $Username = $valid_user;
 $Password = $password;
include("../include/FunctionDB.php");
include("../include/Function.php");
include("admin_menu.php");
ConnectDB();
$sql = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rss = mysql_fetch_array($result);
/////////////////////////////////
$sql2 = "Select * From history_decoration_tb Where Code='$Code'";
$result2= mysql_query($sql2) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result2);

?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style6 {font-size: 14px}
-->
</style>
<table width="809" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="809"><br>
          <fieldset>
            <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_manage.php" >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Adddecoration.php?Teacher_code=<? echo $rss[Teacher_code] ?>">เพิ่มข้อมูลประวัติเครื่องราช</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />แก้ไขข้อมูลประวัติเครื่องราช</font></legend>
            <label><div align="center">
              <form id="form1" name="form1" method="post" action="Editdecora.php">
                <table width="70%" border="0" align="center" cellpadding="0" cellspacing="1" style="background-color:#eeeeee; border:0px solid gray"size="12">
                  <tr bgcolor="#F3D6F2">
                    <td colspan="3" bgcolor="#FFFFFF"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()"  width="85" height="22" border="0" /></font></td>
                  </tr>
                  <tr bgcolor="#F3D6F2">
                    <td colspan="3" bgcolor="#FFFFFF"><div align="center"><font color="#999999" face="Tahoma"><span class="style6"><font color="#CC0000">แก้ไข </font><font color="#000000" face="Tahoma">ประวัติการรับพระราชทานเครื่องราชอิสริยาภรณ</font></span></font><font color="#999999" size="4" face="Tahoma"><strong><font color="#000000" size="4" face="Tahoma">์</font></strong></font></div></td>
                  </tr>
                  <tr bgcolor="#F3F3F3">
                    <td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ชื่อ 
                      - นามสกุล</font></div></td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF">&nbsp;</td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma">&nbsp; <?php echo $rss[First_name] ;?> <?php echo $rss[Teacher_name] ;?> <? echo $rss[Teacher_lastname];?></font><font size="2" face="Tahoma">&nbsp;</font></td>
                  </tr>
                  <tr bgcolor="#F3F3F3">
                    <td width="28%" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ปีที่ได้รับ</font></div></td>
                    <td width="1%" bordercolor="#FFFFCC" bgcolor="#FFFFFF">&nbsp;</td>
                    <td width="71%" bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">ี่ 
                      ปี พ.ศ.
                      <input name="Year_receive" type="text" class="input1" id="Year_receive"  value="<? echo $rs[Year_receive]?>" size="10" />
                    </font></td>
                  </tr>
                  <tr bgcolor="#F3F3F3">
                    <td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ชั้นเครื่องราชฯ</font></div></td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF">&nbsp;</td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><input name="Decoration_name" type="text" class="input1" id="Decoration_name" value="<? echo $rs[Decoration_name]?>" size="50" /></td>
                  </tr>
                  <tr bgcolor="#F3F3F3">
                    <td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">เล่มที่</font></div></td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF">&nbsp;</td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><input name="Volumn" type="text" id="Volumn" value="<? echo $rs[Volumn]?>" size="15" class="input1" />
                        <font size="2" face="Tahoma">ตอนที่
                          <input name="Col" type="text" id="Col" value="<? echo $rs[Col]?>" size="5" class="input1" />
                          หน้าที่
                          <input name="Page" type="text" id="Page" value="<? echo $rs[Page]?>" size="3" class="input1" />
                      </font></td>
                  </tr>
                  <tr bgcolor="#F3F3F3">
                    <td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ลำดับที่</font></div></td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF">&nbsp;</td>
                    <td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><input name="Orderlist" type="text" class="input1" id="Orderlist" value="<? echo $rs[Orderlist]?>" size="10" /></td>
                  </tr>
                  <tr bgcolor="#F3D6F2">
                    <td colspan="3" bgcolor="#FFFFFF"><div align="center">
                        <input type="hidden" name="Teacher_code" value="<? echo $rs[Teacher_code]?>" />
                        <input type="hidden" name="Code" value="<? echo $rs[Code]?>" />
                        <input type="submit" name="Submit" value="   แก้ไข" class="button" />
                    </div></td>
                  </tr>
                </table>
              </form>
              </div>
            </label>
        </fieldset><br>
        <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
      </font></td>
    </tr>
</table>
<?php 
    }
else
{
       echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
       echo"Please Login ";
}
?>