Hi,
I want to split my guestbook entries onto different pages (limit 5 entries per page).
I have searched google and couldnt find an easy way to modify my code to accomodate for this.
Can anyone help?
<?
//the host, name, and password for your mysql
mysql_connect("localhost","user","pass");
//select the database
mysql_select_db("epidemic_guestbook");
if($submit)
{
//use the PHP date function for the time
$offset = 3600*10;
$time = gmdate("dS F Y, G:i", time() + $offset);
// inserting it into the shoutbox table which we made in the mysql statements before
$result=MYSQL_QUERY("INSERT INTO shoutbox (id,name,message,time)".
"VALUES ('NULL','$name', '$message','$time')");
}
?>
<?
//returning the last 5 messages
$result = mysql_query("select * from shoutbox order by id desc limit 5");
//the while loop
while($r=mysql_fetch_array($result))
{
//getting each variable from the table
$time=$r["time"];
$id=$r["id"];
$message=$r["message"];
$name=$r["name"];
?>
<b>Posted by:</b> <font color="red"><? echo $name?></font><br>
<b>Date:</b> <? echo $time?><br>
<b>Message:</b><br>
<? echo wordwrap($message, 50, '<br>',1)?><br><br><br>
<? }?>
