<?php
    }else{
    $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
    $ppp = 5;
    $offset = ($page-1)*$ppp;
    $query = mysql_query("SELECT COUNT(*) AS count FROM blog");
    $row = mysql_fetch_object($query);
    $anzahl = $row->count;
    $rem = $anzahl % $ppp; if($rem > 0) $pages = intval($anzahl / $ppp); else $pages = intval($anzahl / $ppp) + 1;
    $sql = "SELECT * FROM blog ORDER BY id DESC LIMIT $ppp OFFSET $offset";
    mysql_query("SET NAMES 'utf8'");
    $entry = mysql_query($sql,$datenbank) or die(mysql_error());
    while($blog = mysql_fetch_object($entry))
    {
?>
<div id="postinfo">
<div class="cpostinfo">
<h4 id="s1">Post Info</h4>
<p><a href="?p=autor&amp;info=<?php echo $blog->autor ?>" class="ml"><?php echo $blog->autor ?></a><br />
<a href="#" class="ml"><?php echo $blog->datum ?></a><br />
<p class="ml">ID<span><?php echo $blog->id ?></span></p>
<?php
    $abfrage = "SELECT id FROM blog_kommentare WHERE blog_id='".mysql_real_escape_string($blog->id)."'";
    $ergebnis = mysql_query($abfrage);
    $menge = mysql_num_rows($ergebnis);
?>
<a href="?p=blog&amp;mode=view&amp;id=<?php echo $blog->id ?>#comments" class="ml">Kommentare (<?php echo $menge ?>)</a><br />
<a href="?p=blog&amp;mode=view&amp;id=<?php echo $blog->id ?>" class="ml">Permalink</a></p>
</div>
</div>
<div class="entry">
<h2 id="s1"><?php echo $blog->title ?></h2>
<p><span>Eingetragen unter</span> <a href="?p=blog&amp;sel=cat&amp;cat=<?php echo $blog->cat ?>"><?php echo $blog->cat ?></a>
<p>&nbsp;</p>
<?php
    if(strlen($blog->text) >= 500) {
    $blog->text=wordwrap($blog->text,500); //Zeilenumbruch einfügen spätestens nach 200 Zeichen
    $blog->text = substr($blog->text,0,strpos($blog->text,"\n")).'...'; //bei Zeilenumbruch Text abschneinden
    }
    echo($blog->text);
?>
<p>&nbsp;<br />&nbsp;</p>
<p id="s1"><a class="more" href="?p=blog&amp;mode=view&amp;id=<?php echo $blog->id ?>">weiterlesen &raquo;</a></p>
</div>
<?php
    }
?>
<p style="margin-left:auto;margin-right:auto;"><a href="?p=blog&amp;page=<?php if(isset($_GET['page']) == $anzahl) { echo '#'; }else{ echo $_GET['page'] - 1; } ?>">Neuere Beiträge</a>   <a href="?p=blog&amp;page=<?php if(isset($_GET['page']) == '0') { echo '1'; }else{ echo $_GET['page'] + 1; } ?>">Ältere Beiträge</a></p>