<?
//	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[category] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1");
		$arr[category] = $db->fetch($res[category]);
 ?>
  <table width=100%  height=500 border="0" align="left" cellpadding="0" cellspacing="0">
    <tr >
		<td Valign="top" >
		<form name="form3" method="post" action="?name=publish&file=tabain">
		<table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
			<tr class="unnamed1">
				<td align="left" width="60%" class="unnamed2"><A HREF="?name=publish&file=tabain">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนประกาศ <?echo $arr[user][school];?></B></td>
				<td width="20%" class="unnamed2"><div align="right"><B>ระบุชื่อหนังสือที่ต้องการคันหา&nbsp;&nbsp;</B> </div></td>
				<td align="right" width="15%"><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>
<br>
<table width="100%"   border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#999999" bordercolordark="#FFFFFF">
	<tr height=25 bgcolor="#6dbae0">
<?
					 if(($arr[user][work]==8)OR($arr[user][status]==1)){ 	  
?>
		<td width="5%" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3"><B>แก้ไข</B></div></font></td>
<? } ?>
		<td width="5%" 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>
		<td width="55%"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>
	</tr>

 <?
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_PUBLISH,"id","$SQLwhere  year='".$arr[category][name]."' and topic like '%$search%'  ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$search=$_POST[search];
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;
$res[publish] = $db->select_query("SELECT * FROM ".TB_PUBLISH." WHERE  sangkad='".$arr[user][sangkad]."' and year='".$arr[category][name]."' and topic like '%$search%'  OR sangkad='".$arr[usersch][id]."' and year='".$arr[category][name]."' and topic like '%$search%'  ORDER BY id DESC LIMIT $goto, $limit   ");

while($arr[publish] = $db->fetch($res[publish]))
	{
 ?>
<tr bgcolor="#FFFFFF" >
<?
					 if(($arr[user][work]==8)OR($arr[user][status]==1)){ 	  
?>
<td align="center"><A HREF="?name=publish&file=edit&op=publish_edit&id=<?echo $arr[publish][id];?>"><B><img src=" images/admin/edit.gif" ></B></a></td>
<? } ?>
	<td align="center"><? echo $arr[publish][year]; ?></td>
	<td align="left"><? echo $arr[publish][tabain]; ?></td>
	<td align="left"><? echo $arr[publish][topic]; ?></td>
	<td valign="top"align="left">&nbsp;<?echo thai_date_fullmonth(strtotime($arr[publish][date]),'','');?></td>
	<td  valign="top" align="center">
<?
					 if($arr[publish][full_text]){ 	  
?>
<a href="data/publish/<?echo $arr[publish][full_text];?>">ไฟล์ 1</A>,
<? } else {echo "ไม่มีไฟล์แนบ";}?>
 <?
					 if($arr[publish][full_texts]){ 	  
?>
<a href="data/publish/<?echo $arr[publish][full_texts];?>">ไฟล์ 2</A>,
<? } ?>
 <?
					 if($arr[publish][full_textu]){ 	  
?>
<a href="data/publish/<?echo $arr[publish][full_textu];?>">ไฟล์ 3</A>,
<? } ?>
 <?
					 if($arr[publish][full_texto]){ 	  
?>
<a href="data/publish/<?echo $arr[publish][full_texto];?>">ไฟล์ 4</A>,
<? } ?>
</div>
</td>
</tr>
<tr>
<td colspan="6" height="1" class="dotline" color=FFFF00></td>
</tr>
<?
}
?>
</table>
				<?
				SplitPage($page,$totalpage,"?name=publish&file=tabainpublish&op=publish_read");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
			</td>
			</tr>
			</table>