<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE align=center  cellSpacing=0 cellPadding=0 width=100% height="500"border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
<form name="form3" method="post" action="?name=tkk4&file=searchod">
  <table width=100%   border="0" align="right" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td width="600"  class="unnamed2"><div align="left">&nbsp;&nbsp;&nbsp;&nbsp;<B>ทะเบียนรับหนังสือราชการ</B></div></td>
		<td width="230" class="unnamed2"><div align="right"><strong>ระบุชื่อหนังสือ, เลขทะเบียน</strong>&nbsp;&nbsp;</div></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>
<BR>
		  <!-- tkk4 -->
<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0>
 <table width="100%" cellspacing="1" cellpadding="0" >
  <tr bgcolor="#336633" height=25>
		<td  align=center width="120"><font color="#FFFFFF"><B>เลขหนังสือ</B></font></td>
		<td  align=center width="530"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="150" align=center ><font color="#FFFFFF"><B>ว/ด/ป/ที่ส่ง</B></font></td>
		<td width="200"  align=center ><font color="#FFFFFF"><B>จาก</B></font></td>
		<td width="80"  align=center ><font color="#FFFFFF"><B>ดู</B></font></td>
  </tr>  
 <?

//	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]);
//แสดงบทความ
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK4_COMMENT,"id","$SQLwhere catno ='".$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[comment] = $db->select_query("SELECT * FROM ".TB_TKK4_COMMENT." WHERE catno ='".$arr[user][sangkad]."' ORDER BY tkk4_id DESC LIMIT $goto, $limit ");

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

$res[tkk4] = $db->select_query("SELECT * FROM ".TB_TKK4." WHERE id ='".$arr[comment][tkk4_id]."' ");
$arr[tkk4] = $db->fetch($res[tkk4]);	
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk4][cat]."' ORDER BY id ");
	$arr[user] = $db->fetch($res[user]);	
?>
			<tr bgcolor="#FFFFFF">	
			<td valign="top">&nbsp;ศธ&nbsp;<?echo $arr[tkk4][tabain];?></td> 
			<td valign="top"><img src="images/krut.png" width=15 align="absmidd">&nbsp;&nbsp;<?echo $arr[tkk4][topic];?></td>
			<td valign="top"><CENTER><?echo ThaiTimeConvert($arr[tkk4][post_date],'','');?></CENTER></td>
			<td valign="top"><CENTER><? echo $arr[user][category_name];?><br>โทร : <? echo $arr[user][tel];?></CENTER></td>
			<td valign="top"><CENTER>	<A HREF="popup.php?name=tkk4&file=readtkk4_od&id=<?echo$arr[tkk4][id];?> " onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 800} )" class="highslide"><IMG SRC="images/read.png" width="20"></CENTER>
			</td>
		</tr>
        <tr>
             <td colspan="5" height="1" class="dotline" color=FFFF00></td>
        </tr>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 																																	
</table>
 </form>	
 			<?
				SplitPage($page,$totalpage,"?name=tkk4&file=rubod&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
 </TR>
 </TD>
 </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>