Serial Number in PHP-MySQL Pagination -

Serial Number in PHP-MySQL Pagination -

i using simple php-mysql pagination , utilize serial number records. purpose utilize next code,

$serial = 1; $sql= mysql_query("select * table limit $limit"); while($row = mysql_fetch_array($sql)) { $s_num = $serial++; $name = $row['name']; echo $s_num . $name."<br>"; }

now problem serial number start 1 in every page in pagination while need 11-20 in 2nd page, 21-30 in 3rd page , on.

add $page var $_get.

$serial = ($page * $limit) + 1; $sql = mysql_query("select * table limit ".($page * $limit).", $limit"); while($row = mysql_fetch_array($sql)) { $s_num = $serial++; $name = $row['name']; echo $s_num . $name."<br>"; }

this right variable page.should start 0.... other wise serial number start 11....

php mysql pagination