<?php

include("./include/FunctionDB.php");
include("admin_menu.php");
include("./include/Function.php");
ConnectDB();
$sql = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
$result  = mysql_query($sql) or die("Error".mysql_error());
$rs = mysql_fetch_array($result);
    $sql2 ="SELECT * FROM edu_product_tb WHERE Prod_code='$Prod_code'";
  $res = mysql_query($sql2) or die("Cannot Select").mysql_error();
  $row = mysql_fetch_array($res);
?> 

<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">
<!--
.style2 {font-size: 14px}
-->
</style>
<table width="841" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="841" ><br> 
          <fieldset>
            <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php">หน้าหลัก</a> <img src="./picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="SearchRes.php">ค้นหางานวิจัย</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>
  <form id="form1" name="form1" method="post" action="">
    <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#9999FF">
      <tr bgcolor="#D5F0F9">
        <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="#D5F0F9">
        <td colspan="3" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr bgcolor="#D5F0F9">
        <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style2"><font color="#003366" face="Tahoma">แสดงผลงานการผลิต 
          และ เผยแพร่ </font></div></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">ชื่อ-นามสกุล</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma"><strong><? echo $rs[First_name] ;?> <? echo $rs[Teacher_name] ;?> &nbsp;<? echo $rs[Teacher_lastname] ;?> </strong></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td width="25%" bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">ชื่อผลงาน</font></div></td>
        <td width="4%" bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td width="71%" bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"><? echo $row[Product_name]?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td height="22" bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">ประเภทผลงาน</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"> <? echo $row[Product_type]?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">วัน/เดือน/ปี 
          เริ่มผลิต</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">&nbsp;</font></td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <? echo $row[Date_start]?> &nbsp;<font color="#000033">วัน/เดือน/ปี แล้วเสร็จ</font> <? echo $row[Date_finish]?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td height="22" bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">การเผยแพร่</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $row[Propagate]?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td height="22" bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">แหล่งงบประมาณ </font> </div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $row[Fund_resource]?> <font color="#000033">งบประมาณ</font> <? echo $row[Fund]?> </font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td height="20" bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">ประโยชน์ของผลงาน</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $row[Benefit]?></font> </td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF"><div align="left"><font color="#000033" size="2" face="Tahoma">การนำไปใช้อ้างอิง่</font></div></td>
        <td bordercolor="#FEEDF9" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#F2DEFE" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $row[Use_ref]?> </font></td>
      </tr>
      <tr bgcolor="#D5F0F9">
        <td colspan="3" bgcolor="#FFFFFF"><div align="center">
            <input type="button" name="Submit2" value="พิมพ์" class="button" />
        </div></td>
      </tr>
    </table>
  </form>
          </fieldset>
        <br>
        <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
      </font></td>
    </tr>
</table>