php and mysql results display

I am running the following code in a while loop to display results from the database.

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

echo "<tr>\n" .
"<td>{$row['id']}</td>\n" .
"<td>{$row['proxyurl']}</td>\n" .
"<td>{$row['date']}</td>\n" .
"<td>{$row['ip']}</td>\n" .
"<td>{$row['url']}</td>\n" .
"</tr>\n";
} 

PHP:

I would love to be able to display only like the first 50 results and then have a link that says NEXT 50 (or something like that) to display the next results in line.

The SQL query I'm using is:

$query = "SELECT * FROM log WHERE proxyurl = '$proxyurl'";

Code (markup):

Any ideas?

THanks

 

Google for "PHP Pagination". There are a lot of tutorials online.

 

thanks a bunch. i've found some tutorials. might take me a while to get it figured out but i'll give it a shot.