<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE width="100%" align=center  cellSpacing=0 cellPadding=0 border=0>
	<TR>
		<TD valign="top">
<?
$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]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
if($_GET[year]){
	$SQLwhere = " year='".$_GET[year]."' ";
	$SQLwhere2 = " WHERE year='".$_GET[year]."' ";
}

$res[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." $SQLwhere2  ");
$arr[tkk3] = $db->fetch($res[tkk3]);

$res[category] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." WHERE name='".$arr[tkk3][year]."' ");
$arr[category] = $db->fetch($res[category]);
?>
<form name="form3" method="post" action="?name=search&file=tabainbook1"> 
  <table width=100%   border="0" align="right" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td  width="60%"  class="unnamed2"><A HREF="?name=search&file=from ">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนหนังสือเวียนภายใน ปี <? echo $arr[category][name]; ?></B></td>
		<td width="20%" class="unnamed2"><div align="right"><strong>ระบุชื่อหนังสือที่ต้องการคันหา&nbsp;&nbsp;</strong></div></td>
		<td width="15%" 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>
<table width=100%  height=500 border="0" align="right" cellpadding="0" cellspacing="0"Valign="top">
<tr>
<td Valign="top">
<table width="99%"  border="0" align="center" cellpadding="3" cellspacing="2" bordercolor="#999999" bordercolordark="#FFFFFF">
	<tr bgcolor="6dbae0">
		<td width="60%" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">เรื่อง</div></font></td>
		<td width="15%" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">วัน เดือน ปี</div></font></td>
		<td width="20%" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">จาก</div></font></td>
		<td width="5%" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">อ่าน</div></font></td>
	</tr>
<?

$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK3,"id","$SQLwhere and  topic like '%$search%'  ");
$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[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." $SQLwhere2 and topic like '%$search%' ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk3] = $db->fetch($res[tkk3])){
  if ($i%2==0) 
{
				?><tr bgcolor="#F0FFFF"><?
			} else {
				?><tr bgcolor="#FFFFFF"><?
} ?>
	<td class="unnamed2"><div align="left"><img src="images/krut.png" width=15 align="absmiddle">&nbsp;&nbsp;<?echo $arr[tkk3][topic];?></div></td>
	<td class="unnamed2"><div align="center">&nbsp;<?echo ThaiTimeConvert($arr[tkk3][post_date],'','');?></div></td>
	<td class="unnamed2"><div align="left">&nbsp;<? echo $arr[tkk3][posted];?></div></td>
	<td  class="unnamed2"><div align="center">&nbsp;<A HREF="popup.php?name=tkk3&file=readtkk3_1&id=<?echo $arr[tkk3][id];?> " onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide"><img src="images/read.png" width=20></A></div></td>
  </tr>
<?
	$i++;
}
?>
</table>
&nbsp;&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=search&file=tabainbook1&year=".$arr[category][name]."&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
			</TD>
        </TR>
    </TABLE>	
			</TD>
        </TR>
    </TABLE>