Пагинация

<?php
$title = $lang['all_users'];
 
$connect = mysqli_query($sql, "SELECT * FROM `user` ORDER BY `login` DESC") or die(mysqli_error());
$users = array();
while($data = mysqli_fetch_assoc($connect))
$users[] = $data;
?>

$page = $_GET['page'];
if($page == 1)
{
$page = 0;
}
$connect = mysqli_query($sql, "SELECT * FROM `user` ORDER BY `login` DESC LIMIT 10 OFFSET $page * 10 ") or die(mysqli_error());
$users = array();
while($data = mysqli_fetch_assoc($connect))
$users[] = $data;

$count = SELECT COUNT(*) FROM user ; тут запрос сами напишете, ну и не забываем что если записей мало (например < 10) то и страница 1 а не ( 5 / 10 = 0.5) проверки сделать надо
$count = $count / 10;

<?foreach($count as $i):?>
<a href="/?page=<?=$i;?>"><?=$i;?></a>
<?endforeach?>

<?php
$id = (addslashes($_GET['id'])); // Забираем тему статей из URL
$res = mysql_query("select `tema_id`, `tema_name` from `tema`");
$result = mysql_query(" SELECT id, title, zag, anons, text, date, tema, img  FROM articles
                        WHERE tema='$id' ORDER BY id DESC ") or die(mysql_error());
$row = mysql_fetch_array($result);
?>
    <?php while($row = mysql_fetch_array($result)):?>  // Цикл вывода всех статей в этой теме
<!-- тут html код дизайна -->
        <?=$row['id']?>
        <?php echo $row['zag']?>
        <?php echo $row['date']?>
    <? endwhile;?>
<!-- тут хотелось бы пагинатор -->
<? mysql_close();?>

<?for($i = 0;i<$count;$i++)
{
echo '<a href="/?page='.$i.'">'.$i.'</a>';
}
?>

<?php
$id = (addslashes($_GET['id'])); // Забираем тему статей из URL
$res = mysql_query("select `tema_id`, `tema_name` from `tema`");
$result = mysql_query(" SELECT id, title, zag, anons, text, date, tema, img  FROM articles
                        WHERE tema='$id' ORDER BY id DESC ") or die(mysql_error());
 
$count = mysql_query(" SELECT COUNT id, title, zag, anons, text, date, tema, img  FROM articles
                        WHERE tema='$id' ORDER BY id DESC LIMIT ") or die(mysql_error());
$count = $count / 5;
 
$row = mysql_fetch_array($result);
?>

$result = mysql_query(" SELECT COUNT(*) as count FROM articles WHERE tema='$id'") or die(mysql_error());
$count = mysql_fetch_assoc($result);
$count = $count['count'];

<?php
include_once("db_blog.php");
 
$id = $_GET['id'];
$res = mysql_query("select `tema_id`, `tema_name` from `tema`");
$result = mysql_query(" SELECT id, title, zag, anons, text, date, tema, img  FROM articles
                        WHERE tema='$id' ORDER BY id DESC LIMIT ") or die(mysql_error());
$result_count = mysql_query(" SELECT COUNT(*) as count FROM articles WHERE tema='$id'") or die(mysql_error());
$count = mysql_fetch_assoc($result_count);
$count = $count['count'];
$count = $count / 5;
$row = mysql_fetch_array($result);
?>

$result = mysql_query(" SELECT id, title, zag, anons, text, date, tema, img  FROM articles
                        WHERE tema='$id' ORDER BY id DESC ") or die(mysql_error());

<? var_dump ($count);?>
<?foreach($count as $i):?>
<a href="/?page=<?=$i;?>"><?=$i;?></a>
<?endforeach?>

<?foreach($count as $i):?>
<a href="/?page=<?=$i;?>"><?=$i;?></a>
<?endforeach?>

<?
for($i = 0;$i<$count;$i++)
{
echo '<a href="/?page='.$i.'">'.$i.'</a>';
}
?>

$count =  ceil($count);

<?
for($i = 1;$i<$count;$i++)
{
echo '<a href="/?page='.$i.'">'.$i.'</a>';
}
?>

<?php
$title = $lang['all_users'];
$all_users = mysqli_num_rows(mysqli_query($sql, 'SELECT * FROM `user`'));
$lines_per_page = 5;
 
if (isset($_GET['page']))
{
    $limit = (($_GET['page'] * $lines_per_page) - $lines_per_page);
}
else
{
    $limit = 0;
}
if (($limit + $lines_per_page) > $all_users)
{
    $offset = $all_users - $limit;
}
else
{
    $offset = $lines_per_page;
}
 
$connect = mysqli_query($sql, 'SELECT * FROM `user` LIMIT '.$limit.', '.$offset.'') or die(mysqli_error($sql));
 
$users = array();
while($data = mysqli_fetch_assoc($connect))
$users[] = $data;
?>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1