สอบถาม จาก PHP Sorting Columns In MySQL คลิกที่ Column แล้วจัดเรียงข้อมูลด้วย PHP กับ MySQL

<a href="<?=$_SERVER["PHP_SELF"];?>?sort=CustomerID">CustomerID</a></div>

$sql="select categoryid,categoryname from category ";
$rscategory = mysql_query($sql);
$totalrecord = mysql_num_rows($rscategory);


$pagesize = "10";
$totalpage = (int) ($totalrecord / $pagesize);
if (($totalrecord % $pagesize) != 0) {
	$totalpage += 1;
}

if (isset($pageid)) {
	$start = $pagesize * ($pageid - 1);
} else {
	$pageid = 1;
	$start = 0;
}
$count  =1;


$strSort = $_GET["sort"];
if($strSort == ""){
	$strSort = "categoryid";
}

$strOrder = $_GET["order"];
if($strOrder == ""){
	$strOrder = "ASC";
}

$sql .=" order  by ".$strSort." ".$strOrder." LIMIT ".$start.", ".$pagesize;
$rscategory  = mysql_query($sql);

$strNewOrder = $strOrder == 'DESC' ? 'ASC' : 'DESC';
?>

if($totalpage>1) {
	echo "<div class=paginationTG>";
 
	$prev1=$pageid-1;
	$next1=$pageid+1;

	echo "<a href=".$PHP_SELF."?pageid=1&sort=$strSort><<</a>";

	if ($pageid>1) {
		echo "<a href=".$PHP_SELF."?pageid=$prev1&sort=$strSort><</a>";
	}
	
	for ($i=($_GET['pageid']-5); $i<=($_GET['pageid']+5); $i++) {
		if($i >0 && $i<= $totalpage) {

			if ($i == $_GET['pageid']) {
				echo "<span class=currentpage>".$i ."</span> &nbsp; ";
			} else {
				echo "<a href=".$PHP_SELF."?pageid=".$i."&sort=$strSort>".$i."</a> &nbsp; ";
			}
		}
	}		

	if ($pageid<$totalpage) {
		echo "<a href=".$PHP_SELF."?pageid=".$next1."&sort=$strSort>></a>";
	}

	echo "<a href=".$PHP_SELF."?pageid=".$totalpage."&sort=$strSort>>></a>";
	echo "</div>";
}