$topics_per_page = 500;
$page = (is_numeric($_GET['page']) ? $_GET['page'] : '1');
$end = $page * $topics_per_page;

$res = mysql_query('SELECT `topic_id` FROM `phpbb_topics`');
$no_topics = mysql_num_rows($res);
$max_page = ceil($no_topics/$topics_per_page);
    if($no_topics == 0){
        echo 'No topics!';
        exit;
    }
echo '<br />';
echo ($page > 1 ? '<a href="?page='.($page - 1).'">Back</a> ' : 'Back ') .' '. $page.'/'.$max_page. ($page < $max_page ? ' <a href="?page='.($page+1).'">Next</a>' : ' Next');
echo '<br />';

$result = mysql_query("SELECT topic_title, topic_id FROM phpbb_topics ORDER BY topic_title LIMIT ($end-$topics_per_page),$topics_per_page;");

while($row=  mysql_fetch_assoc($result))

{
      echo "<a href='viewtopic.php?t=".$row["topic_id"]."'>".$row["topic_title"]."</a><br>";