Файл: news.php
Строк: 18
<?
include'dobavka/head.php';
include'dobavka/conf.php';
include'dobavka/sess.php';
include'dobavka/tabl.php';
//////////////////////////////////
$sum = 25; // число записей на странице
$result = mysql_query("SELECT count(*) as a from news");
$arr = mysql_fetch_row($result);$rec = $arr[0];
if(!isset($_GET['str'])){$str = 0;}else
{$str = $_GET['str'];}$start = $str * $sum;
$r = mysql_query("SELECT * FROM news order by `id` desc LIMIT $start, $sum");
$n = mysql_num_rows($r);for ($i = 0; $i < $n; $i++){
////////////////вывод
$m= mysql_fetch_array($r);
$y1=$m['data'];$y2=$m['avtor'];$y3=$m['news'];
echo"($y1)<b>$y2</b><br/>$y3<br/>----<br/>";
////////////////
}
///////////////навигация
if ($str > 0){$p = $str - 1;
echo "<a href=news.php?der=$key&str=$p>НАЗАД</a>";}
$str++;if($start + $n < $rec)
echo "<a href=news.php?der=$key&str=$str>ДАЛЕЕ</a>";
//////////////
//////////////////////////////////
include_once("dobavka/foot.php");
?>