<link href="style_web.css" rel="stylesheet" type="text/css">
	<TABLE cellSpacing=0 cellPadding=0 width=100% height=400 align="center"border=0>
      <TBODY>
        <TR>
<?
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
if($_GET[sangkad]){
	$SQLwhere = " sangkad='".$_GET[sangkad]."' ";
	$SQLwhere4 = " WHERE sangkad='".$_GET[sangkad]."' ";
}

		$res[user] = $db->select_query("SELECT * FROM ".TB_user." $SQLwhere4  ORDER BY id DESC LIMIT 1 ");
		while ($arr[user] = $db->fetch($res[user])){

		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."'  ");
		$arr[usersch] = $db->fetch($res[usersch]);
?>		
          <TD  align="center" vAlign=top></a>&nbsp;&nbsp;&nbsp;	<FONT COLOR=blue><b>บุคลากรในอดีตของโรงเรียน<?=$arr[usersch][name];?> </b></FONT>
			<BR><div align="left"><B><a href="?name=usersch&amp;file=usersch_school&amp;op=user_add"><img src="images/admin/user.gif"  border="0" align="absmiddle" /> เพิ่มผู้ใช้ใหม่</a>&nbsp;&nbsp;&nbsp;<a href="?name=usersch&file=editschool&sangkad=<?=$arr[usersch][id];?>"><img src="images/admin/user.gif"  border="0" align="absmiddle" /> กลับหน้าบุคลากรปัจจุบัน</a></B></div>
<?
}
 ?>
  <table width="100%" cellspacing="2" cellpadding="1" >
											<tr bgcolor="#99ccff" height="25">
                                                <td align="center"><b>ที่</b></td>
                                                <td align="center">ชื่อ - นามสกุล</td>
                                                <td align="center">ตำแหน่ง</td>
												<td align="center">สถานะ</font></div></td>
												<td align="center">แก้ไขข้อมูล</font></div></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]);
//แสดงบทความ
if($_GET[sangkad]){
	$SQLwhere = " sangkad='".$_GET[sangkad]."' ";
	$SQLwhere2 = " WHERE sangkad='".$_GET[sangkad]."' ";
}
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_user,"id","$SQLwhere  status='2' ");
$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[user] = $db->select_query("SELECT * FROM ".TB_user." $SQLwhere2 AND status='2' ORDER BY level ASC LIMIT $goto, $limit   ");
$count=0;
$i=1;
while($arr[user] = $db->fetch($res[user]))
	{
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."' ");
$arr[usersch] = $db->fetch($res[usersch]);
	 if ($i%2==0) 
{
	?><tr bgcolor="#C9FBC8" class="unnamed1"><?
} else {
	?><tr bgcolor="#E6FE99" class="unnamed2"><?
} ?>

	<td  width="5%"  align="center"><? echo"".$i?></td>
   <td width="30%"  ><?echo $arr[user][category_name];?></td>
	<td  width="35%" ><?echo $arr[user][posit];?></td>
	<td width="5%" align="center">ปิด</td>
	<td width="10%" align="center"><a href="?name=admin&amp;file=user_schoolkru&amp;op=minepass_edit&amp;id=<? echo $arr[user][id];?>"><font color="#FF0000"><img src="images/edits.png" border="0" alt="แก้ไข" /></font></a> </td>
  </tr>  
	<?
$count++;
$i++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
				</table>

 </form>		
 </TD>
 </TR>
 </TABLE>

				<BR>
				<table border="0" cellpadding="0" cellspacing="1" width="100%" align=center>
					<tr>
						<td>
	
				<?
			SplitPage($page,$totalpage,"?name=approvalkru&file=adeet&sangkad=".$_GET[sangkad]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?> 
					</TD>
				</TR>
			</TABLE>
			<!-- Admin -->
		  </TD>
        </TR>
      </TBODY>
    </TABLE>