Next/Prev buttons Hints and Help?

Anon

I am using a list script, but i have so many links so i need a multi page can anybody help me ??
My script :
<?
{
//Først connect'er vi til databasen.
$conn_id = mysql_connect("myhost", "username", "password")
OR DIE ("MySQL couldn't connect");
mysql_select_db("demodl")
OR DIE ("MySQL couldn't find the database");

$noResult = "Nothing found";

$query = mysql_query("SELECT * FROM cracks WHERE name like '$name%' ORDER BY name "); 
while ($row  =  mysql_fetch_array($query)) 
{ 
	$id = $row["id"];
	$name = $row["name"];
	$link = $row["link"];
	$dato = $row["dato"];
	$hits = $row["hits"];
            print ("<center><tr><td><b><a href=\"cgi-bin/serial.php?id=$id\">$name</a></td><td><b><center> $hits</td></tr></b></center>"); 
} 

	if (!$id)  
{ 
	print ("$noResult"); 
}

}//end if
?>

Hope you can read my english :-))

Anon

what you need to do is set the limit by adding a $start variable to the script... Then your query would look like this

"SELECT * FROM cracks WHERE name like '$name%' ORDER BY name LIMIT $start, $end";

the $end should be something like $end = $start + 20;

To go to the next page first do $end++; and then simply print "<a href=$PHP_SELF?start=$end>neste side</a>" or something like that.

Understand?

Andreas Bernhardsen

Anon

The LIMIT keyword in your query is what you use to contrain your query to X records, however, the second parameter is the amount of records you want. So it should be a fixed number determined beforehand, like this:

$limit = 10;
$sql = "SELECT * FROM cracks WHERE name like '$name%' ORDER BY name LIMIT $offset, $limit";

this would return you the next 10 records starting at $offset. Where $offset is passed to your script. Check out the Next/Prev button article here at phpbuilder, it is very handy. I modified it a bit to suit my site but it works pretty well as it is.