การทำลิส โดยใช้ปุ่มรูปภาพแทนการป้อนตัวเลข

<table width="100%" border="0" cellspacing="0" cellpadding="4">
      <tr>
        <td height="12" colspan="8"><strong>จัดการเว็บบอร์ด</strong></td>
      </tr>
      <tr>
        <td height="25" colspan="2" align="center" class="txtbar"><strong>Page Name</strong></td>
        <td height="25" align="center" class="txtbar"><strong>List</strong></td>
        <td width="6%" align="center" class="txtbar"><strong>Online</strong></td>
        <td width="6%" align="center" class="txtbar"><strong>Level</strong></td>
        <td width="18%" height="25" align="center" class="txtbar"><strong>Last Update</strong></td>
        <td width="7%" height="25" align="center" class="txtbar"><strong>Delete</strong></td>
        <td width="9%" height="25" align="center" class="txtbar"><strong>Preview</strong></td>
      </tr>
      <? $nwsql="select * from category_board order by c_list asc";
	  $nwqr=mysql_db_query($db,$nwsql);
	  while($nwrs=mysql_fetch_array($nwqr)){
	  $num=mysql_num_rows($nwqr);
	  $i++;
	  
	  $online=$nwrs['c_online']; 
	  $id=$nwrs['c_id'];
	  $clv=$nwrs['c_level'];
	  if($online==0){
	  $on="<a href='category.online.php?id=$id&amp;o=1'><img src='imgs/error.gif' alt='' width='16' height='16' border='0' /></a>";
	  } if($online==1){
	  $on= "<a href='category.online.php?id=$id&amp;o=0'><img src='imgs/true.gif' alt='' width='16' height='16' border='0' /></a>";
	  }
	  
	  if($clv==0){
	  $lv="<img src=\"imgs/member.png\" alt=\"\" width=\"16\" height=\"16\"  border='0'  />";
	  } if($clv==1){
	  $lv= "<img src=\"imgs/admin.png\" alt=\"\" width=\"16\" height=\"16\"  border='0' />";
	  }
	  $list=$nwrs['c_list'];
	  
	  
	  ?>
      <tr>
        <td width="3%" height="25" valign="top"><img src="imgs/php.gif" alt="" width="16" height="16" /></td>
        <td width="43%" valign="top"><a href="category.edit.php?id=<?php echo $nwrs['c_id']; ?>">
          <?php echo $nwrs['c_title']; ?>
          </a><br />
          <span class="style1">
          <?php echo $nwrs['c_descript']; ?>
        </span></td>
        <td width="8%" align="center" valign="top"><? if($num>=2){?> <table width="32" border="0" cellpadding="0" cellspacing="0">
		<? if($list==1){ ?>
          <tr>
            <td width="16"><a href="category.list.php?down=1&amp;list=<?php echo $nwrs['c_list']; ?>&amp;id=<?php echo $nwrs['c_id']; ?>"><img src="imgs/down.gif" alt="down" width="16" height="16" border="0" /></a></td>
            <td width="16">&nbsp;</td>
          </tr><? } if($list!=1 and $list!=$num){ ?>
          <tr>
            <td><a href="category.list.php?down=1&amp;list=<?php echo $nwrs['c_list']; ?>&amp;id=<?php echo $nwrs['c_id']; ?>"><img src="imgs/down.gif" alt="down" width="16" height="16" border="0" /></a></td>
            <td><a href="category.list.php?list=<?php echo $nwrs['c_list']; ?>&amp;up=1&amp;id=<?php echo $nwrs['c_id']; ?>"><img src="imgs/up.gif" alt="up" width="16" height="16" border="0" /></a></td>
          </tr><? } if($list==$num){ ?>
          <tr>
            <td width="16">&nbsp;</td>
            <td><a href="category.list.php?list=<?php echo $nwrs['c_list']; ?>&amp;up=1&amp;id=<?php echo $nwrs['c_id']; ?>"><img src="imgs/up.gif" alt="up" width="16" height="16" border="0" /></a></td>
          </tr><? } ?>
        </table>    <? } ?>      </td>
        <td height="25" align="center" valign="top"><?php echo $on; ?></td>
        <td height="25" align="center" valign="top"><?php echo $lv; ?></td>
        <td height="25" align="center" valign="top"><?php echo $nwrs['c_date']; ?></td>
        <td height="25" align="center" valign="top"><a href="category.del.php?id=<?php echo $id; ?>&amp;t=<?php echo $num; ?>&amp;list=<?php echo $nwrs['c_list']; ?>" onclick="return confirm('แน่ใจว่าต้องการลบ')"><img src="imgs/icon_delete.gif" alt="" width="17" height="17" border="0" /></a></td>
        <td height="25" align="center" valign="top"><a href="../s-forum/sboards.php?board=<?php echo $nwrs['c_id']; ?>"><img src="imgs/icon_preview.gif" alt="" width="16" height="16" border="0" /></a></td>
      </tr>
      <? } ?>
      <tr>
        <td height="25" colspan="5"><strong><a href="category.add.php">Add Boards </a>... </strong></td>
        <td height="25" colspan="3" align="right">&nbsp;</td>
      </tr>
      <tr>
        <td height="25" colspan="5"><img src="imgs/true.gif" width="16" height="16" align="absmiddle" /> หมายถึง สถานะบอร์ดที่ สามารถ โพสได้ทุกคน<br />
          <img src="imgs/error.gif" width="16" height="16" align="absmiddle" /> หมายถึง สถานะบอร์ดที่สามารถเพิ่มได้ เฉพาะ ผู้ดูแลระบบ </td>
        <td height="25" colspan="3" align="right">&nbsp;</td>
      </tr>
    </table>

<? include("_session.php");
$up=$_GET['up'];
$down=$_GET['down'];
$id=$_GET['id'];
$clist=$_GET['list'];
echo "up : $up <br>down : $down<br>id : $id";
if($up==1){

$list=$clist-$up;

   /*  $nwsql="select * from category_board where c_list='$list'";
	  $nwqr=mysql_db_query($db,$nwsql);
	  $nwrs=mysql_fetch_array($nwqr);
	  
	  $u=$nwrs['c+list'];
	  $uu=$u+1;
	  */

$usql="update category_board set c_list='$clist' where c_list='$list'";
$uqr=mysql_db_query($db,$usql);

$dsql="update category_board set c_list='$list' where c_id='$id'";
$dqr=mysql_db_query($db,$dsql);

header("Location:category.php");
exit(); 
}

if($down==1){
$list=$down+$clist;
$usql="update category_board set c_list='$clist' where c_list='$list'";
$uqr=mysql_db_query($db,$usql);

$dsql="update category_board set c_list='$list' where c_id='$id'";
$dqr=mysql_db_query($db,$dsql);

header("Location:category.php");
exit(); 
}

?>

<? ob_start();
@session_start();
$user="root";
$pass="1125";
$host="localhost";
$db="freelance";

$con=mysql_connect($host,$user,$pass);

mysql_query("SET NAMES tis620"); 
if(!$con){
echo "Error ไม่สามารถติดต่อฐานข้อมูลได้";
exit();
}


$id=$_GET['id'];
$o=$_GET['o'];
$clist=$_GET['list'];
$t=$_GET['t'];
$sql="select * from category_board where c_list between '$clist' and '$t' order by c_list asc";
$qr=mysql_db_query($db,$sql);
while($rs=mysql_fetch_array($qr)){
$ls=$rs['c_list'];
$list=$ls-1;
$d=$rs['c_id'];
$lsql="update category_board set c_list='$list' where c_id='$d'";
$lqr=mysql_db_query($db,$lsql);
}
$upql="delete from category_board where c_id='$id'";
$upqr=mysql_db_query($db,$upql);

$upql="delete from board where c_id='$id'";
$upqr=mysql_db_query($db,$upql);

if($upqr){
?><script language="javascript">window.history.back(-1); </script> <?
exit();
} else {
?><script language="javascript">alert("ไม่สามารถปรับปรุงข้อมูลได้ โปรดทำรายการใหม่ภายหลัง"); window.history.back(-1); </script>  <?
}
?>