advance button

[proctk]

Hi

 

On the bottom of many forms and long web pages there are numbers on the bottom of the page that gets the next x entrys.  I know how to do this with a link and advance x at a time.  On many websites there is a little box with the number 1,2,3 etc that is clickable to advance the query.

 

can anyone point me to a tutorial to show how to do this

 

thank you

[teng84]

it called paging and with the box it done by using and CSS around that number or image as bacground image of the div for the css actually you can do it in other way

 

now search in the google paging or sql paging

[proctk]

thanks that helped huge, I did not know the technical name

[teng84]

thanks that helped huge, I did not know the technical name

is this solved???

[cooldude832]

actual its called pagnation and the basic concept is this

<?php
$resultsperpage = 20; //Number of Results per Page
$currentpage = $_GET['Page'];
$min = $currentpage*$resultsperpage;
$max = $min+$resultsperpage;

$sql = "select some stuff from table where some more stuff limit ".$min.",".$max". Order by Some stuff";
?>