Next/Back links if statement
Posted: Sat Nov 16, 2002 7:37 pm
Code: Select all
<?
include("guestbook/connect.php");
function dateParse($date)
{
return $dateї2] . $dateї3] . "." . $dateї4] . $dateї5] . "." . $dateї0] . $dateї1];
}
if (!isset($page))
$page=0;
if ($page < 0)
die("Illegal page value");
$offset = 0;
$number = 10;
$sql = "SELECT * FROM guestbook ORDER BY id DESC LIMIT " . ($number*$page) . "," . ($number*$page+10) . "";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
while($result = mysql_fetch_array($query)) {
$Name = stripslashes($resultї"Name"]);
$date = stripslashes($resultї"date"]);
$Email = stripslashes($resultї"Email"]);
$Comments = stripslashes($resultї"Comments"]);
echo "<table width=95% cellpadding=0 cellspacing=0><tr><td class=titletable><a href=mailto:$Email>$Name</a> on " . dateParse($date) . "</td></tr><tr><td>$Comments</td></tr></table><br>";
}
if ($page == 0)
print "<a href=guestbook.php?page=" . ($page+1) . ">Next</a>";
if ($page > 0)
print "<a href=guestbook.php?page=" . ($page-1) . ">Previous</a> | <a href=guestbook.php?page=" . ($page+1) . ">Next</a>";
?>