<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE width="100%"  align=center  cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD  align=center 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]);
?> 
<form name="form3" method="post" action="?name=tkk9&file=search"> 
<table width=100%   border="0" align="right" cellpadding="0" cellspacing="0">
<tr class="unnamed1">
<td  width="60%"  class="unnamed2"><A HREF="?name=tkk9&file=rad">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนรับเอกสารทั่วไป ของ <? echo $arr[user][category_name];?></B></td>
<td width="15%" class="unnamed2"><div align="right"><strong>ระบุชื่อหนังสือที่ต้องการคันหา</strong></div></td>
<td width="10%" align="right" ><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
<td width="5%"><div align="right"><input type="submit" name="Submit2" value="ค้นหา">&nbsp;&nbsp;</div></td>
</tr>
</table>
</form>
</TD>
</TR>
<TR>
<TD>
<TABLE width="100%" height=500 align=center  cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD valign="top">
 <TABLE width="100%"  align=center  cellspacing="1" cellpadding="1" >
  <tr bgcolor="6dbae0" height=25>
   <td width="50%" align="center"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
   <td width="15%" align="center"><font color="#FFFFFF"><B>วันที่ส่ง</B></font></td>
   <td width="20%" align="center"><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
   	<td width="5%"  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]);
//แสดง
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK9_COMMENT,"id","$SQLwhere  catno='".$arr[user][id]."' ");
$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_TKK9_COMMENT." WHERE   catno='".$arr[user][id]."' 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[tkk9] = $db->select_query("SELECT * FROM ".TB_TKK9." WHERE id='".$arr[comment][tkk9_id]."'  ORDER BY id ");
	$arr[tkk9] = $db->fetch($res[tkk9]);
?>
 <tr bgcolor="#FFFFFF">
			<td valign="top">&nbsp;<img src="images/arrow_b.gif" width=15 align="absmiddle">&nbsp;&nbsp;<?echo $arr[tkk9][topic];?></td>
			<td valign="top" align="center" ><?echo ThaiTimeConvert($arr[tkk9][post_date],'','');?></td>
			<td valign="top"> <? echo $arr[tkk9][posted];?></td>
			<td valign="top" align="center"  ><font color="#339900"><a href="?name=tkk9&file=readtkk9_2&id=<?echo $arr[tkk9][id];?>"><img src="images/read.png" width=20></font></td>
		</tr>
            <tr>
             <td colspan="5" height="1" class="dotline" color=FFFF00></td>
            </tr>
	<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</table>
&nbsp;&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=tkk9&file=rad&op=tkk9_read&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
			</TD>
        </TR>
    </TABLE>	
		  </TD>
        </TR>
      </TBODY>
    </TABLE>