i have created a guestbook for my website, but everytime i add a comment it just put the comment below the other. I want it so that the first page only shows maybe 35 comments, then a new page will be created and then 35 comments can be placed there etc.
echo "<h1>guestbook</h1>";
echo "<hr />";
$form = "
<form action='index.php' method='POST'>
<table>
<tr>
<td>name:</td>
<td><input type='text' name='name' /></td>
</tr>
<tr>
<td>message:</td>
<td><textarea rows='5' cols='30' name='message'></textarea></td>
</tr>
<tr>
<td></td>
<td><input type='submit' name='submit' /></td>
</tr>
</table>
</form>
";
include "connect.php";
$getdata = mysql_query("SELECT * FROM guestbook ORDER BY id DESC");
while($row = mysql_fetch_assoc($getdata))
{
$id = $row['id'];
$name = $row['name'];
$message = $row['message'];
$date = $row['date'];
$message = nl2br($message);
echo "
<table>
<tr>
<td><strong>lastet opp av $name. Dato: $date</strong></td>
</tr>
<tr>
<td>$message</td>
</tr><br />
</table>
";
}
echo "<hr />";
$submit = $_POST['submit'];
if($submit)
{
$name = $_POST['name'];
$message = $_POST['message'];
if($name && $message)
{
include "connect.php";
$query = mysql_query("SELECT * FROM guestbook WHERE name='$name' && message='$message'");
$numrows = mysql_num_rows($query);
if($numrows == 0)
{
mysql_query("INSERT INTO guestbook VALUES('','$name','$message',CURDATE())");
echo "du har sent en melding $form";
}
else
{
echo "du kan ikke sende den samme meldingen om igjen $form";
}
}
else
{
echo "du må fylle ut skjemaet $form";
}
}
else
{
echo $form;
}
?>