Languages: PHP + MySQL.

After having several large tables which display the results on one large page, how do you get the results to appear like search engines or this forum where you have 10/20 items listed and you have the next and previous result page links??





Michael.

__________________
Michael.

You'd probably use querystring values. Something like http://www.mikesserver.co.uk/list.php?start=10

You'd extract the starting point from the URL...
$start = $_GET['start'];

Work out the finish (i'll assume you want them to come ten at a time):

$end = 10 + $start;

Carry out your query using the LIMIT keyword:

$query = "SELECT lots,of,stuff FROM table LIMIT $start, $end";
$result= mysql_query($result) or die ("Argh! I choke. I die. I cough my last, cursing my creator, because he asked me to &quot;$query&quot;"); //<- don't do this on a live server

And put a hyperlink at the bottom of the page, like this:
echo "<a href=\"list.php?start=$end\">Howay! Giz anuther ten!</a>";

You could put in all sorts of traps like this:

if($end > mysql_num_rows($result)){
//Don't output that hyperlink
}

...and:

if($start>=10){
$start = $start -10:
echo "<a href=\"list.php?start=$start\">Wat wes the ten afooa like, marra?</a>";
}

...and so, ad infinitum.

Dan