her er koden
<?
//skab forbindelse til databasen
mysql_connect("****", "****", "****") or die(mysql_error());
mysql_select_db("sjov") or die(mysql_error());
$offset = (is_numeric($_GET['offset']))?intval($_GET['offset']):0;
$max_pages = 2;
$count = mysql_result(mysql_query('SELECT COUNT(tekstID) FROM tekster'),0);
$query = mysql_query("SELECT tekstID, tekst, titel FROM tekster ORDER BY tekstID LIMIT " . $offset . "," . $max_pages) or die(mysql_error());
{
echo '<table>' . "\n";
echo '<tr><td>Link</td></tr>' . "\n";
while($row = mysql_fetch_assoc($query))
{
echo '<tr><td><a class="menu" href="' . $_SERVER['PHP_SELF'] . '?text=' . $row['tekstID'] . '&offset='.$offset.'" title="' . $row['titel'] . '">' . $row['titel'] . '</a></td></tr>' . "\n";
}
echo '</table>' . "\n";
}
// Lav relevante links
if ($offset > 0)
{
if(is_numeric($_GET['text']))
{
$id = intval($_GET['text']);
echo '<a href="' . $_SERVER['PHP_SELF'] . '?text='.$id.'&offset='.($offset - $max_pages).'">Forrige</a>';
}
else
{
echo '<a href="' . $_SERVER['PHP_SELF'] . '?offset='.($offset - $max_pages).'">Forrige</a>';
}
}
else
{
echo 'Forrige';
}
echo ' | ';
if ($offset + $max_pages < $count)
{
if(is_numeric($_GET['text']))
{
$id = intval($_GET['text']);
echo '<a href="' . $_SERVER['PHP_SELF'] . '?text='.$id.'&offset='.($offset + $max_pages).'">Forrige</a>';
}
else
{
echo '<a href="' . $_SERVER['PHP_SELF'] . '?offset='.($offset + $max_pages).'">Forrige</a>';
}
}
else
{
echo 'Næste';
}
if(is_numeric($_GET['text']))
{
$id = intval($_GET['text']);
$query = mysql_query("SELECT tekst FROM tekster WHERE tekstID = '".$id."' LIMIT 1");
$tekst = mysql_result($query,0);
echo '<p>';
echo $tekst;
echo '</p>';
}
?>
