$pagesize = 20;
// แบ่งหน้าแสดงผล
$sql = "SELECT count(id) as countid FROM table";
$cre = mysql_query($sql);
$crow = mysql_fetch_row($cre);
$totalrecord = $crow[0];
$totalpage = ceil($totalrecord / $pagesize);
if (isset($_GET['pageid'])) {
$start = $pagesize * ($_GET['pageid'] - 1);
}
else {
$pageid = 1;
$start = 0;
}
$sql = "SELECT * FROM table LIMIT $start, $pagesize;";
$result = mysql_query($sql) or die ( mysql_error());
while ($row = mysql_fetch_assoc($result) ) {
$adata[] = $row;
}
// ข้อมูล ที่ต้องการ ใส่ลงในหน้า
for ($i=1; $i<=$totalpage; $i++) {
if ($i == $_GET['pageid']) {
echo $i . " ";
} else {
echo "ใส่ลิงค์ ";
}
}
เพิ่ม เติมอีก เวอร์ ชั่น นะครับ
include 'library/config.php';
include 'library/opendb.php';
// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = " SELECT val FROM randoms " .
" LIMIT $offset,
$rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
// print the random numbers
while($row = mysql_fetch_array($result))
{
echo $row['val'] . '
';
}
// ... more code here
?>