จะตัดแถวที่ query จาก database มาทั้งหมด แล้วตัดแถวให้แสดงตามจำนวนที่เราต้องการ

<?
if($_GET["txtKeyword"] != "")
	{
	$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
	$objDB = mysql_select_db("admin");
	// Search By Name or Email
	mysql_query("SET NAMES UTF8");
	$strSQL = "SELECT * FROM book WHERE (call_number LIKE '%".$_GET["txtKeyword"]."%' or name_book LIKE '%".$_GET["txtKeyword"]."%'
	or name_author LIKE '%".$_GET["txtKeyword"]."%')";
	
	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
	$Num_Rows = mysql_num_rows($objQuery);


	$Per_Page = 10;   // Per Page 

	$Page = $_GET["Page"];
	if(!$_GET["Page"])
	{
		$Page=1;
	}

	$Prev_Page = $Page-1;
	$Next_Page = $Page+1;

	$Page_Start = (($Per_Page*$Page)-$Per_Page);
	if($Num_Rows<=$Per_Page)
	{
		$Num_Pages =1;
	}
	else if(($Num_Rows % $Per_Page)==0)
	{
		$Num_Pages =($Num_Rows/$Per_Page) ;
	}
	else
	{
		$Num_Pages =($Num_Rows/$Per_Page)+1;
		$Num_Pages = (int)$Num_Pages;
	}


	
	$objQuery  = mysql_query($strSQL);


	?>
	<table width="600" border="1">
	  <tr>
		<th width="91"> <div align="center">call_number </div></th>
		<th width="98"> <div align="center">name_book </div></th>
		<th width="198"> <div align="center">name_author </div></th>

		<th width="198"> <div align="center">สถานะ </div></th>
		</tr>
	<?
	while($objResult = mysql_fetch_array($objQuery))
	{
	?>

	  <tr>
		<td><div align="center"><?=$objResult["call_number"];?></div></td>
		<td><?=$objResult["name_book"];?></td>
		<td><div align="center"><?=$objResult["name_author"];?></div></td>
		<td><div align="center">
		<?
		

	 
	  </div></td>
	  </tr>



	<?
	}
	?>
	</table>
	<br>
	Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
	<?
	if($Prev_Page)
	{
		echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
	}

	for($i=1; $i<=$Num_Pages; $i++){
		if($i != $Page)
		{
			echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
		}
		else
		{
			echo "<b> $i </b>";
		}
	}
	if($Page!=$Num_Pages)
	{
		echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
	}
	
	mysql_close($objConnect);
	}?>