Next / Previous

[Anon]

How can i build a next / previous using the mysql database. I am extracting data like this. $sql = "SELECT page, text from $table_name where page = $page";
$result =@($sql,$connection) or die("Couldn't ececute query.");
while ($row = mysql_fetch_array($result)) {
$text = $row['text'];
}
$display_block .= "$text";

I need to be able to go to the next page.

[radley]

PHPBuilder has a great tutorial on this.
<a href='http://phpbuilder.com/columns/rod20000221.php3'>http://phpbuilder.com/columns/rod20000221.php3</a>

[Anon]

This is what I've come up with:

<?
if(empty($from)) $from = 0;
if(empty($size)) $size = 5;

$dbQuery = mysql_query("SELECT COUNT(lID) AS lCount FROM tNews") or die(mysql_error());
$dbRow = mysql_fetch_array($dbQuery);
$count = $dbRow['lCount'];

$dbQuery = mysql_query("SELECT sTitle, sText FROM tNews ORDER BY dWrite DESC LIMIT $from, $size") or die(mysql_error());
while($dbRow = mysql_fetch_array($dbQuery))
{
echo($dbRow['sTitle'].'<br>'.str_replace("\n", "\n<br>", $dbRow['sText']).'<br><br>');
}
if($from > 0) echo('<a href="?from='.max(($from-$size), 0).'&size='.$size.'">Previous</a>');
if(($from+$size) < $count) echo('<a href="?from='.($from+$size).'&size='.$size.'">Next</a>');
?>

[Anon]

I came up with just what i need

$pag =$page + 1;
$url = "conserv.php?page=$pag";
$next ="<a href=\"$url\"><font size=2>Next</font></a>";
if ($page < 12) {
$next1 = "$next";
} else {
$next1="";
}

$pag1 =$page - 1;
$url1 = "conserv.php?page=$pag1";
$prev = "<a href=\"$url1\"><font size=2>Previous</font></a>";
if ($page > 1) {
$prev1 = "$prev";
} else {
$prev1="";
}

[Anon]

Thank you! Now the Problem has been solved!! Great!!!!!!!!!!!1