<?
if ($newspage)
{
$newsstart=($newspage-1)*5;
}
else
{
$newsstart=0;
}
$news=mysql_query("select * from news order by id desc limit $newsstart,5",$db);
while ($new=mysql_fetch_row($news))
{
$users=mysql_query("select * from users where id='$new[4]'",$db);
$user=mysql_fetch_array($users);
?>
<div class="news-item">
<h4 class="news-header"><? printf($new[1]); ?></h4>
<div class="news-user"><? printf($user[1]); ?></div>
<div class="news-date"><? printf($new[3]); ?></div>
<p class="news-text"><? printf(nl2br(htmlentities($new[2]))); ?></p>
</div>
<?
}
$news=mysql_query("select * from news",$db);
$num_news=mysql_num_rows($news);
if ($num_news>5)
{
$num_pages=$num_news/5;
if ($num_pages>round($num_pages))
{
$num_pages=round($num_pages)+1;
}
else
{
$num_pages=round($num_pages);
}
printf("Page ");
for ($counter=1;$counter<=$num_pages;$counter++)
{
?>
<a href="<? printf('index.php?page=%s',$counter); ?>"><? printf($counter); ?></a>
<?
}
}
?>