<?
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>
		<TABLE width="100%" align=center cellSpacing=1 cellPadding=0 border=0>
		<TR bgcolor="#6dbae0" height=25>
			<TD   align=center width="10"><font color="#FFFFFF"><B>ที่</B></font></TD>
			<TD   align=center width="140"><font color="#FFFFFF"><B>เลขหนังสือ</B></font></TD>
			<TD  align=center width="550"><font color="#FFFFFF"><B>เรื่อง</B></font></TD>
			<TD   width="120"  align=center ><font color="#FFFFFF"><B>วัน เดือน ปี</B></font></TD>
			<TD  width="60" align=center ><font color="#FFFFFF"><B>แก้ไข</B></font></TD>
			<TD  align=center width="120"><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_TKK7,"id","$SQLwhere");
$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[tkk7] = $db->select_query("SELECT id, tabain, topic, posted, full_text, full_texts, full_textu, full_texto, post_date, UNIX_TIMESTAMP(date) AS date2 FROM ".TB_TKK7." WHERE posted='".$arr[usersch][id]."'  ORDER BY post_date DESC LIMIT $goto, $limit   ");
$count=0;
$i=1;
while($arr[tkk7] = $db->fetch($res[tkk7]))
	{	
?>
			<TR bgcolor="#FFFFFF">
			<TD align="center" ><?echo $arr[tkk7][id];?></TD> 
			<TD align="left" ><?echo $arr[tkk7][tabain];?></TD> 
			<TD valign="top"><?echo $arr[tkk7][topic];?></TD>    
			<TD align="center" > <?= ThaiTimeConvert($arr[tkk7][date2]);?></TD> 
			<TD align="center" ><B><A HREF="?name=tkk7&file=addarea2&op=tkk7_edit&id=<?echo $arr[tkk7][id];?>"><FONT COLOR="#FF0000" >แก้ไข</FONT></a> 
			</TD>
			<TD align="center" ><B><A HREF="?name=tkk7&file=readtkk7_3&id=<?echo $arr[tkk7][id];?>"><FONT COLOR="#FF0000" ><img src="images/read.png" width=20/></FONT></a>
			</TD>
			</TR>
            <TR>
             <TD colspan="5" height="1" class="dotline" color=FFFF00></TD>
            </TR>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</TABLE>
&nbsp;&nbsp;
<?
				SplitPage($page,$totalpage,"?name=tkk7&file=checkschool&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
?>
		</TR>
		</TD>
		</TABLE>