What is wrong with this paging code?
Posted: Sat Aug 17, 2002 8:44 am
When loaded it seems alright, but when you press next it shows 6 results even if paging_beg and paging_end have the values 3 and 6... What is wrong here?!?!
Code: Select all
<?php
include('myCommon.php');
db_Connect();
$sql = "SELECT id FROM table";
$resultset = mysql_query($sql);
$row = mysql_fetch_row($resultset);
$total_records = $rowї0];
mysql_free_result($resultset);
$paging_size = 3;
if(empty($pageid))
{
$pageid = 1;
}
$paging_end = $pageid * $paging_size;
$paging_beg = $paging_end - $paging_size;
$pageid++;
$sql = "SELECT id, heading FROM table ORDER BY start_date DESC LIMIT $paging_beg, $paging_end";
$resultset = mysql_query($sql);
while($myrow = mysql_fetch_array($resultset))
{
printf("%s %s <br>", $myrowї"id"], $myrowї"heading"]);
}
mysql_free_result($resultset);
echo "<br> Total records: $total_records | Next pageid = $pageid | Paging start = $paging_beg | Paging end = $paging_end | -> <a href="test.php?pageid=$pageid">next</a>";
?>