Next and previous links

[astm]

the following code read from database by limit to show 2 records

now i want to make link or button to show the next 2 records or the previons 2 records

please tell me how i can do that ??????????????? :o

the cod is

<?

$link = mysql_connect("localhost","","")
or die("error connect");

$dbrusult=mysql_db_query("mydata","select * from table LIMIT 0, 2 ");

echo ("");

echo ("NO");
echo ("NAME");
echo ("Country");

while ($row=mysql_fetch_array($dbrusult))
{
echo "";
echo "$row[0]";
echo "$row[1]";
echo "$row[2]";
echo "";
}
echo ("");
mysql_free_result($dbrusult);
mysql_close($link);

?>

[samaru]

If you're trying to make a PHP record paging page, I suggest you look at:

http://www.daniweb.com/techtalkforums/thread1720.html