$comment =($_REQUEST['comment']);
$autor = ($_REQUEST['autor']);
$time = StrFTime("%Y-%m-%d %H:%M:%S");
$schreiben=true;
if($comment != '' and $autor != '') {
// guckn, ob Doppelcomment
$query = "SELECT * FROM comments WHERE (`category` = \"$category\") ORDER BY `id` DESC LIMIT 1";
$result = mysql_query($query);
echo mysql_error();
$row = mysql_fetch_array($result);
if(($row['comment'] == $comment) and ($result)){
$schreiben =false;}
$id = $row['id']+1;
if ($schreiben){
$query = "INSERT INTO comments (category ,id, comment, author, date) VALUES ('$category','$id','$comment', '$autor', '$time')";
$data = mysql_query($query);
}}
else{
echo "Bitte gültige Daten angeben.
";}
//höchste id rausfinden
$query = "SELECT * FROM comments WHERE (`category` = \"$category\") ORDER BY `id` DESC LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$highestid = $row['id'];
// Kommentare anzeigen
$id = $_REQUEST['id'];
if (isset($_REQUEST['commentpage'])){
$page = $_REQUEST['commentpage'];
}
else{
$page =1;}
$seitenanfang=$highestid-($page-1)*5;
$query = "SELECT * FROM comments WHERE (`category`=\"$category\" and((`id` <= $seitenanfang) and (`id` >= ".max(1,$seitenanfang-4)."))) ORDER BY `id` DESC";
$data = mysql_query($query);
?>
$count = 0;
while ($row = mysql_fetch_array($data)){
echo '';
$count = $count+1;
}
$i = 0;
$temp = 0;
$Seitenangabe = 'Seite: ';
while ($i <= $highestid) {
if (($i%5) == 0 ) {
$temp = $temp +1;
$link =$_SERVER['PHP_SELF'];
$Seitenangabe= "$Seitenangabe $temp";
}
$i++;
}
echo "$Seitenangabe";
?>
'; echo ('