<?php
    $db = new mysqli ("localhost","root","","tankbase");


    $limit=2;
$allnews=4;
if(isset($_GET['pg'])){
    $start = (($_GET['pg']*$limit)-$limit);
    }
    else{
        $start = 1;
        }
if(($start+$limit)>$allnews){
    $kolvo = $allnews-$start;
    }
    else{
        $kolvo = $limit;
        }

    if ($allnews > $limit)
{
       $r = 1;
       while ($r <= ceil($allnews/$limit))
       {
            {

              echo '<a href=?pg="'.$r.'">',$r,'</a>';
           }
            $r++;
       }
}

$result = $db->query("select * from news order by id desc LIMIT $start,$kolvo");

$news_ar = array();
while( $row = $result->fetch_assoc() ){
  $news_ar = $row;
}
    var_dump($news_ar);
  foreach ($news_ar as  $news) {


    echo $news->image,'<br>';

     echo $news->text_head,'<br>';

    echo substr($news->text, 0,100),'<br>';
  }


    ?>