<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
 <?
//	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]);
?>
<TABLE cellSpacing=0 cellPadding=0 width=1005 border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
<form name="form3" method="post" action="?name=tkk3&file=tabainuser">
  <table width=100% border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td width="730" ><img src="images/back.png" align="absmiddle">&nbsp;&nbsp;<B>ทะเบียนรับหนังสือเวียนภายในของ <?echo $arr[user][category_name];?></B>
		</td>
		<td width="100" align="right">ระบุเงื่อนไข&nbsp;&nbsp;</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=1005 height=500 border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=0>
  <tr bgcolor="#CCFF66" height=25>
	<td width="40"  align="center"><B>ที่</B></td>
   <td width="460" align="center"><B>เรื่อง</B></td>
   <td width="200" align="center"><B>ผู้ส่ง</B></td>
   <td width="200" align="center"><B>วันที่ส่ง</B></td>
   <td width="100" align="center"><B>สถานะการรับ</B></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[year] = $db->select_query("SELECT * FROM ".TB_YEAR_CAT." ORDER BY id ");
		$arr[year] = $db->fetch($res[year]);
//แสดง
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK3_COMMENT,"id","$SQLwhere  name='".$arr[user][category_name]."' ");
$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_TKK3_COMMENT." WHERE   name='".$arr[user][category_name]."' ORDER BY id DESC LIMIT $goto, $limit   ");

while($arr[comment] = $db->fetch($res[comment]))
	{
	//Check Comment
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." WHERE id='".$arr[comment][tkk3_id]."'  ORDER BY id ");
	$arr[tkk3] = $db->fetch($res[tkk3]);
?>

			<tr bgcolor=#FFFFFF>			
				<td valign="top"align="center" ><?echo $arr[tkk3][id];?></td>
				<td valign="top"><a href="javascript:NewWindow('popup2.php?name=tkk3&file=readtkk3_1&id=<?echo $arr[tkk3][id];?>','acepopup','1024','720','center','front');"><?echo $arr[tkk3][topic];?></a> <?=$CommentIcon;?><?=NewsIcon(TIMESTAMP, $arr[tkk3][post_date], "images/icon_new.gif");?>
				</td>
				<td valign="top"><CENTER><? echo $arr[tkk3][posted];?> </CENTER></td>
				<td valign="top" align="center" ><?echo ThaiTimeConvert($arr[tkk3][post_date],'','2');?></td>
				<td valign="top" align="center"  ><a href="javascript:NewWindow('popup2.php?name=tkk3&file=readtkk3&id=<?echo $arr[tkk3][id];?>','acepopup','1024','720','center','front');"><img src="images/read.png" width=20 align="absmiddle"></a></font></td>
		</tr>
        <tr>
                <td colspan="5" height="1" class="dotline" color=FFFF00></td>
        </tr>

<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
		</table>
				<?
				SplitPage($page,$totalpage,"?name=tkk3&file=rab&op=tkk3_read&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>		
		  </TD>
        </TR>
    </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>