<div align="left">
	  <table cellspacing="0" cellpadding="0" width="100%" height=450 border="0">
        <tbody>
          <tr>
            <td valign="top" width="100%" > <a href='index.php'>
                        <img src="images/admin/exit.gif" width="35" height="35"align="middle" border="0"alt="ออกจากหน้านี้" /></a><div align="center">
			<table width="100%">
                          <tr>   
						<td align="center"">
							<br>
							<font color=red><b>แสดงข้อมูลจำแนกรายโรง</b></font>
							</td>
							
							</tr>
							</table>
                <table cellspacing="0" cellpadding="0" width="98%" border="0">
                  <tbody>
                    <tr>
                      <td><table width="100%">
                          <tr>
                            <td align="center">
                              <table width="100%" align="center" cellspacing="0" cellpadding="0" border="0">
                                <tr>
                                  <td align="center">
                                      <!-- แสดงผลรายการสมาชิกเว็บ -->
                                      <?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 200 ;
$SUMPAGE = $db->num_rows(TB_user,"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 ;
?>
                                      <form action="?name=user&amp;file=user_cp&amp;op=user_del&amp;action=multidel" method="post" name="myform" id="myform">
                                       <table width="100%" cellspacing="2" cellpadding="1" >
  <tr bgcolor="#00FFFF" height=25> 
    <td rowspan="2"  align=center>ที่</td>
    <td rowspan="2"  align=center>โรงเรียน</td>
    <td height="37" colspan="3"  align=center>ข้อมูลการพัฒนา</td>
  </tr>
  <tr bgcolor="#336633" height=25> 
    <td  align=center bgcolor="#00FFFF">การอบรม</td>
    <td  align=center bgcolor="#00FFFF">ยกย่องเชิดชูเกียรติ</td>
    <td height="37"  align=center bgcolor="#00FFFF">ดูรายละเอียด</td>
  </tr>
 <?
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE level='3' ORDER BY id ASC LIMIT $goto, $limit ");
$i=1;
while($arr[user] = $db->fetch($res[user])){
	$res[groups] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." WHERE id='".$arr[user][level]."' ");
	$arr[groups] = $db->fetch($res[groups]);


?>
					
<tr bgcolor="#CCFFFF" height=25> 
    <td width="5%"  align=center><? echo"".$i?></td>
    <td width="26%"  ><A HREF="?name=guide&file=checkschool&school=<?=$arr[user][category_name];?> "><? echo $arr[user][category_name];?></a><?=$arr[guide][category];?></td>
<?
$res[guide] = $db->select_query("SELECT * FROM ".TB_GUIDE." WHERE school='".$arr[user][category_name]."'  ORDER BY id DESC LIMIT 1 ");
$count=0;
while($arr[guide] = $db->fetch($res[guide])){

?>

    <td width="19%"  align=center>
	<?php
// Make a MySQL Connection
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT category SUM(category) FROM web_course GROUP BY id"; 
$sql1="select sum(category=1) as tt1 from web_course where school='".$arr[user][category_name]."'  ";
			$dbquery1 = mysql_db_query($dbname, $sql1);
			$result1 = mysql_fetch_array($dbquery1);
			$total1=$result1[tt1];
?>
	<? echo $total1,''; ?>
	</td>
    <td width="18%"  align=center>
<?php
// Make a MySQL Connection
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT category SUM(category) FROM web_awards GROUP BY id"; 
$sql2="select sum(category=1) as tt2 from web_awards where school='".$arr[user][category_name]."' ";
			$dbquery2 = mysql_db_query($dbname, $sql2);
			$result2 = mysql_fetch_array($dbquery2);
			$total2=$result2[tt2];
?>
	<? echo $total2,''; ?>
	</td>
    <td width="17%"  align=center><A HREF="?name=guide&file=myreport&school=<?=$arr[user][id];?> "><img src="images/View.png"  width="20" height="20"align="middle" border="0" /></a></td>
  </tr>

<?
 } 
?>
                                        

                                          <tr bgcolor=FFFFFF>
                                            <td colspan="9" height="1" class="dotline">
											
											</td>
                                          </tr>


<?
$i++;
 } 
?>
                                        </table>

                                      </form>
									  <BR>
<div align="left">
  <?
	SplitPage($page,$totalpage,"?name=tkk6&file=userkm");
	echo $ShowSumPages ;
	echo "<BR>";
	echo $ShowPages ;
	echo "<BR><BR>";
	

//$res[groupstext] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." ORDER BY id ");
//while ($arr[groupstext] = $db->fetch($res[groupstext]))
 //  {
		//echo "<LI><B>".$arr[groupstext][name]." : </B>".$arr[groupstext][description]."</LI>";
 //  }
//$db->closedb ();

}
?>
</div>
                                    <br />
                                  </td>
                                </tr>
                              </table>
</td>
                                </tr>
                              </table>
                            <br /></td>
                          </tr>
                      </table></td>
                    </tr>
                  </tbody>
                </table>