<div align="center">
<TABLE cellspacing="0" cellpadding="0" width="100%" height=450 border="0">
                  <tbody>
                    <tr>
                       <td vAlign=top>
<form name="form3" method="post" action="?name=user&file=user_od_school">
  <table width=100%  border="0" align="right" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td  width="600" class="unnamed2">
		&nbsp;&nbsp;&nbsp;<br /> 
		</td>
		<td width="200" class="unnamed2">
			<div align="right">
			<strong>ระบุชื่อที่ต้องการค้นหา</strong>
			</div>
		</td>
		<td width="120">
			<label>
			</label>
				<input name="search" type="text" id="search" value="<?=$_GET["search"];?>">
		</td>
      <td width="80">
        <div align="left">
          <input type="submit" name="Submit2" value="ค้นหา">
        </div></td>
    </tr>
  </table>

  <br>
  </form>
<?
//////////////////////////////////////////// แสดงรายชื่อ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 100 ;
$SUMPAGE = $db->num_rows(TB_user,"id"," level='3'  and status='4'");
$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 ;
?>
                                 <table width="100%" align="center" cellspacing="2" cellpadding="1" >
                                          <tr bgcolor="#009900" height="25">
                                            <td width="250"><div align="center"><font color="#FFFFFF"><b>ชื่อ - นามสกุล</b></font></div></td>
											<td width="230"><div align="center"><font color="#FFFFFF"><b>ตำแหน่ง</b></font></div></td>
                                            <td width="200"><div align="center"><font color="#FFFFFF"><b>อำเภอ</b></font></div></td>  
                                            <td width="200"><div align="center"><font color="#FFFFFF"><b>โทรศัพท์</b></font></div></td>               
                                          </tr>
     <?
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE  category_name like '%$search%' and level='3' and status='4' ORDER BY sangkad ASC LIMIT $goto, $limit ");
while($arr[user] = $db->fetch($res[user])){
	$res[working] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[user][working]."'  ");
	$arr[working] = $db->fetch($res[working]);
	$res[work] = $db->select_query("SELECT * FROM ".TB_WORK_CAT." WHERE  id='".$arr[user][work]."' ");
	$arr[work] = $db->fetch($res[work]);
	$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE  id='".$arr[user][sangkad]."' ");
	$arr[usersch] = $db->fetch($res[usersch]);
	$res[amp] = $db->select_query("SELECT * FROM ".TB_AMP_CAT." WHERE  id='".$arr[usersch][address]."' ");
	$arr[amp] = $db->fetch($res[amp]);
  if ($i%2==0) 
{
	?><tr bgcolor="#FFFFC6" class="unnamed1"><?
} else {
	?><tr bgcolor="ffffff" class="unnamed1"><?
} ?>
                                            <td>&nbsp;&nbsp;&raquo;&nbsp;<? echo $arr[user][category_name];?></td>
											<td><? echo $arr[user][posit];?><? echo $arr[user][school];?></td>
											<td><? echo $arr[amp][category_name];?></td>
											<td><? echo $arr[user][tel];?></td>
                                          </tr>

<?
	$i++;
 } 
?>
                                        </table>
                                      </form>
                                    <?
	SplitPage($page,$totalpage,"?name=user&file=user_od_school");
	echo $ShowSumPages ;
	echo "<BR>";
	echo $ShowPages ;
	echo "<BR><BR>";
}
 
?>

                                  </td>
                                </tr>
                              </table>
							</td>
                          </tr>
                      </table>
          </tr>
        </tbody>
      </table>
	  
</div>