<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=500  align=center  border=0>
      <TBODY>
		<TR>
          <TD vAlign=top>
<?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);

		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
?> 
<form name="form3" method="post" action="?name=tkk2&file=tabainsongschool">
  <table width=100% align=left cellpadding=0 cellspacing=0>
    <tr class="unnamed1">
		<td align=left width="600" class="unnamed2">
		<A HREF="?name=tkk2&file=tabainsongschool">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<font color=red><B>ทะเบียนส่งหนังสือราชการของ  <? echo $arr[usersch][name];?></font></B>
		</td>
		<td width="230"align="right"><B>ระบุชื่อหนังสือที่ต้องการค้นหา&nbsp;&nbsp;</B></td>
		<td width="100"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
		<td width="70"><div align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>
  </form>
  </TD>
  </TR>
  <TR>
  <TD>
<TABLE cellSpacing=0 cellPadding=0 width=100%  height=500 align=center  border=0>
      <TBODY>
		<TR>
          <TD vAlign=top>
<table width="100%"  border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#ccdd3d" bordercolordark="#FFFFFF">
	<tr bgcolor="#336633">
		<td  align=center width="130"><font color="#FFFFFF"><B>เลขทะเบียน</B></font></td>
		<td  width="730" align=center ><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="100" align=center ><font color="#FFFFFF"><B>วัน-เดือน-ปี</B></font></td>
		<td width="40" align=center ><font color="#FFFFFF"><B>ดู</B></font></td>
	</tr>
<?
//แสดง
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK2,"id","$SQLwhere tabain like '%$search%' and posted='".$arr[user][sangkad]."' or topic like '%$search%' and posted='".$arr[user][sangkad]."'  ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;

$res[tkk2] = $db->select_query("SELECT * FROM ".TB_TKK2." WHERE tabain like '%$search%' and posted='".$arr[user][sangkad]."'  or topic like '%$search%' and posted='".$arr[user][sangkad]."' ORDER BY id DESC LIMIT $goto, $limit ");

while($arr[tkk2] = $db->fetch($res[tkk2])){

if ($i%2==0) 
{
				?><tr bgcolor="#F0FFFF"><?
			} else {
				?><tr bgcolor="#FFFFFF"><?
} ?>  
	<td valign="top"><div align="left">&nbsp;<? echo $arr[tkk2][tabain]; ?></div></td>
    <td valign="top"><IMG SRC="myoffice/<? echo $arr[tkk2][praphet];?>.png" Width=10 Height=10 align="absmiddle">&nbsp;&nbsp;<? echo $arr[tkk2][topic]; ?></td>
	<td valign="top"><div align="center">&nbsp;<?echo ThaiTimeConvert($arr[tkk2][post_date],'','');?></div></td>
	<td  valign="top" align="center"><A HREF="popup.php?name=tkk2&file=readtkk2_3&id=<? echo $arr[tkk2][id]; ?> " onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide"><img src="images/read.png" width=20></A></div></td>
  </tr>
<?
	$i++;
}
?>
</table>
				<?
				SplitPage($page,$totalpage,"?name=tkk2&file=tabainsongschool&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
		  </TD>
        </TR>
    </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>