<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>
<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
$page = (int) $_GET['page'];
$max= "10";
$end = $page+$max;
$select = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT $page,$end")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$news = mysql_result($select, $i, "news");
echo '<table width="300" height="10" border="0">';
echo '<tr><td>Име на новина: <b>'.$name.'</b></td>
<tr><td>Новината: <b>'.$news.'</b></td></tr>
<br /><hr>';
}
$next = $end+1;
$prev = $page-10;
echo "<a href=\"index.php?page=".$next."\">следваща</a>";
echo "<a href=\"index.php?page=".$prev."\">предишна</a>";
mysql_close();
?>
