<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_pwd']);
?>
<TABLE align=center cellSpacing=0 cellPadding=0 width=100% height="500"border=0>
      <TBODY>
			<TR>
					<TD width="100%" vAlign=top>
					<form action="?name=admin&file=tkk2&op=tkk2_del&action=multidel" name="myform" method="post">
					<TABLE width="100%" cellspacing="2" cellpadding="1" >
						<TR bgcolor="6dbae0" height=25>
							<TD  align=center width="5%"><font color="#FFFFFF"><B>ที่</B></font></TD>
							<TD  align=center width="10%"><font color="#FFFFFF"><B>เลขหนังสือ</B></font></TD>
							<TD  align=center width="55%%"><font color="#FFFFFF"><B>เรื่อง</B></font></TD>
							<TD  width="15%"  align=center ><font color="#FFFFFF"><B>วัน เดือน ปี</B></font></TD>
							<TD  align=center width="15%"><font color="#FFFFFF"><B>สถานะหนังสือ</B></font></TD>
						</TR>  
 <?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE username='".$_SESSION['usersch_user']."' ");
		$arr[usersch] = $db->fetch($res[usersch]);

//แสดงบทความ
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$limit = 10 ;
		$SUMPAGE = $db->num_rows(TB_TKK2,"id","$SQLwhere posted='".$arr[usersch][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[tkk2] = $db->select_query("SELECT * FROM ".TB_TKK2." WHERE tabain like '%$search%' and posted='".$arr[usersch][id]."' and status='2' or topic like '%$search%' and posted='".$arr[usersch][id]."' and status='2' ORDER BY id DESC LIMIT $goto, $limit ");

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

$res[working] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[tkk2][group_ska]."' ");
$arr[working] = $db->fetch($res[working]);
 if ($i%2==0) 
{
				?><tr bgcolor="#F0FFFF"><?
			} else {
				?><tr bgcolor="#F8F8FF"><?
} ?>
			<TD valign="top" align="center" ><?echo $arr[tkk2][id];?></TD> 
			<TD valign="top" align="left" ><?echo $arr[tkk2][tabain];?></TD> 
			<TD valign="top" valign="top"><IMG SRC="images/krut.png" Width=10 Height=10 align="absmiddle">&nbsp;&nbsp;<?echo $arr[tkk2][topic];?>
			</TD>
			<TD valign="top" align="center" ><div align="center"><?echo thai_date_and_time_short($arr[tkk2][post_date],'1','');?></div></TD> 
			<TD valign="top" align="center"  >
			<?
				$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk2][category]."'  ");
				$arr[user] = $db->fetch($res[user]);
			?>
				<A HREF="?name=tkk2&file=addarea2&op=tkk2_edit&id=<?echo $arr[tkk2][id];?>"><FONT COLOR="#000000" >ตรวจสอบแก้ไข</FONT></a>	</font>
				</div>
			</TD>
	</TR>
<?
	$i++;
?>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?>
</TABLE>
&nbsp;&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=tkk2&file=checkarea&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?> 	
			</TD>
		</TR>
</TABLE>