Prev next links

[Anon]

Heres a newbie question

Using the following code how can I make it only display 5 results with hyperlinks to get the next and prev 5 results and also display the total amount of results found?

I have tryed many scripts on other developer sites and the featured article on this site by Rod but couldn't get them to work properly. Any help would be greatly appreciated!!!

Thankyou

$username="myusername";
$password="mypassword";
$database="mydatabase";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM audio WHERE category='$keyword'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$html=mysql_result($result,$i,"html");

echo "$html
";

++$i;

}

[cyzsuraj]

Hello,

I am assuming you are browsing through 'category's using next & prev.

Try this in your while loop or wherever you display your links:

echo "<a href=\"$SCRIPT_NAME?keyword=$keyword+1\">Link1</a>";

$keyword+1 should be the next and
$keyword-1 should be the previous.

I hope that gives you an idea on howto do this, my answer may not be specific enough for your purposes, but I have done my best based on the information given.

Good luck,
Suraj