$Per_Page = 10;
$Page = isset($_GET['Page'])? $_GET['Page'] : 1;
$strSQL = '
select * from
(select row_number() over (order by Name1 ) as row,* from customer) as t
where row between '.(($Page-1)*$Per_Page +1).' and '.($Page*$Per_Page);
$rs = {.... query with your tool};
$strSQL_count = "SELECT count(*) c from customer ";
.... query with your tool
$num_row = { .....query with your tool };
แต่ที่สำคัญได้ทำ index เพื่อการคิวรี่ไว้หรือเปล่าครับ