I have this code:

PHP Code:
<?php
$db
="dbname";
$connect mysql_connect('localhost''user''pass');
  if (! 
$connect)
  die(
"Couldn't connect to MySQL");
mysql_select_db($db $connect) or die("Select Error: ".mysql_error());
  
$query="SELECT id, headline, DATE_FORMAT(abdate, '%d.%m.%y %H:%i') AS date FROM table ORDER BY date DESC LIMIT 0, 70";
echo 
"<tr><td width='100%' valign='top'><br><font size='2'><b>News</b></font><br></td></tr></table><table width=100% cellpadding=2 cellspacing=2>";
$results mysql_query($query)
  or die(
mysql_error());
while (
$row mysql_fetch_array($results)) {
  
extract($row);
  echo 
"<tr><td><font size='1'>$date:&nbsp;</font><a href='news.php?news=$id'>$headline</a><br></td></tr>";
}
mysql_close($connect);
?>
It displays the newest 70 results, what I want is to be able to show more results using paging and 70 results per page.

<<- 1 2 3 4 5 6 7 8 9 10 ->>

The page I'm on will not be clickable. etc... Just like other websites paging. And when you are on e.g. page 7.. these will show.. eg...

<<- 2 3 4 5 6 7 8 9 10 11 ->>

I for sure hope someone can help me out! would be delighted!
I've tried myself but never got it to work. But I've been told its easy, but I'm not to good at PHP :/