สอบถามเรื่อง การแบ่งหน้าครับ พอดีส่งค่ามา select ข้อมูลโดย WHERE ค่าที่ส่งมา เพื่อเเสดงข้อมูลครับ

 <?

include("db_connect.php");


	// Search By Name or Email
	$strSQL1 = "SELECT * FROM product join product_category on 		  	    product.Product_Category_ID = product_category.Category_ID  JOIN product_category_sub ON product.Sub_ID = product_category_sub.Sub_ID WHERE  ID_agent='".$_POST['ID_agent']."'  ";
	$objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL1."]");
	$Num_Rows = mysql_num_rows($objQuery1);
	?>
            
            
            <?



$Per_Page = 15;   // 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;
}

$strSQL1 .=" order  by Product_Category_ID ASC LIMIT $Page_Start , $Per_Page";
$objQuery1  = mysql_query($strSQL1);
?>
            
            <table width="845" border="0">
              <tr>
                <th width="88" bgcolor="#66FFCC"> <div align="center">Image</div></th>
                <th width="97" bgcolor="#66FFCC"> <div align="center">รหัสสินค้า</div></th>
                <th width="185" bgcolor="#66FFCC"> <div align="center">ชื่อสินค้า </div></th>
                <th width="83" bgcolor="#66FFCC"> <div align="center">ประเภท</div></th>
                <th width="83" bgcolor="#66FFCC"> <div align="center">หมวดหมู่</div></th>
                <th width="47" bgcolor="#FFFF99">detail</th>
                <th width="48" bgcolor="#FF6666"> <div align="center">เลือก</div></th>
                </tr>
              <?
	while($objResult1 = mysql_fetch_array($objQuery1))
	{
	?>
              <tr>
                <td align="center" bgcolor="#D9F2ED"><img src="myfile/product/<?php echo $objResult1["Product_Image"];?>" width="50" height="50"></td>
                <td align="center" bgcolor="#D9F2ED"><div align="center"><?php echo $objResult1["Product_Id"];?></div></td>
                <td align="center" bgcolor="#D9F2ED"><?php echo $objResult1["Product_Name"];?></td>
                <td align="center" bgcolor="#D9F2ED"><?php echo $objResult1["Category_Name"];?></td>
                <td align="center" bgcolor="#D9F2ED"><?php echo $objResult1["Sub_Name"];?></td>
                <td align="center" bgcolor="#D9F2ED"><img src="picture/stock_view-details.png" width="25" height="22"></td>
                <td align="center" bgcolor="#D9F2ED"><a href="admin_management_orderstock_agent_order.php?Product_Id=<?php echo $objResult1["Product_Id"];?>" class="popup" ><img src="picture/select-button.png" width="62" height="23"></a></td>
                </tr>
              <?
	}
	?>
              </table>
  <br>
            Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
  <?
if($Prev_Page)
{
	echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){
	if($i != $Page)
	{
		echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
	}
	else
	{
		echo "<b> $i </b>";
	}
}
if($Page!=$Num_Pages)
{
	echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
}
?>
</th>
  </tr>
</table>
      </fieldset>
      
   </td>
  </tr>
</table>
	<? mysql_close();
?>