PHP:
<?php
$runq = mysql_query("SELECT * FROM `posts`");
$pageNum = mysql_num_rows($runq);
$limit = 8;
if((int)$_GET['page']>0) {
$page = (int)$_GET['page'];
}
else {
$page = 0;
}
$maxPages = ceil($pageNum/$limit);
$runq = mysql_query("SELECT * FROM `posts` ORDER BY post_id DESC LIMIT ".$limit*$page.", ".$limit."") or die (mysql_error());
while($row = mysql_fetch_assoc($runq)) {
echo '
<div class="menu_head_style">
<h3 class="titlelink"><a href="preview.php?article='.$row['post_id'].'">'.$row['title'].'</a></h3>
</div>
<div class="menu_style">
<div class="pad">'.$row['content'].'</div>
<div style="color: #000; background: #e7e7e7; border: 1px solid #e0e0e0; padding: 3px 0 3px 0; border-left: none; border-right: none; border-bottom: none;">
<table width="100%" border="0">
<tr>
<td style="text-align: left; font: 11px verdana; ">Категория
: <a href="index.php?news=cats&cat=3"><b>'; if($row['cat'] == 1) {
$cat = 'За сайта';
echo"$cat";}
if($row['cat'] == 2) {
$cat = 'За мен';
echo"$cat";}
echo'</b></a></td>
<td style="text-align: left; font: 11px verdana;">Oт: <i>'.$row['added'].'</i></td>
<td style="text-align: right; font: 11px verdana; "><a href="preview.php?article='.$row['post_id'].'" style="color: #000; text-decoration: none; font: 12px arial;">Коментари
(<span style="font: bold 13px verdana; color: #333;">';
$post_id = $row['post_id'];
$runq = mysql_query("SELECT * FROM `commenta` WHERE post_id='$post_id'") or die (mysql_error());
$uNum = mysql_num_rows($runq);
echo "$uNum";
echo '</span>)</a></td>
</tr>
</table>
</div>
</div>';
}
?><br /><br /><br /><div class='pages'>
<span style='font: 11px arial; color: #333;'><?
if($data['cat'] == $id) {
for($i=0;$i<$maxPages;$i++) {
echo " [<a href='music.php?&page=".$i."'> ".($i+1)."</a> ] ";
}
}
?></div>Ето реално демо:
http://penchev-bg.eu/s/
