Проблем с извеждане на данни

N

niko_nik

Registered
Проблема се състои в това че на всяка страница ми показва последната написана новина а не подрет и страницирането ми е вертикално а не хоризонтално ':roll:' понеже не съм много на ти с пхп ако може някой да ми помогне ще съм му много благодарен това е кода

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?php
session_start();
require ('system.php');
require ('settings.php');
$id = (int)$_GET['topic'];
$sql = mysql_query("SELECT * FROM `news` WHERE `id` = '$id'") or die (mysql_error());
$n = mysql_fetch_assoc($sql);
$num = $n['num'] + 1;
$update = mysql_query("UPDATE `news` SET `num` = '$num' WHERE `id` = '$id'") or die (mysql_error());

if($_GET['page']){
$page = (int)$_GET['page'];
} else {
$page = 1;
}

$end = 1;
$max = 5;
$table = "news";

$plink = "news.php?topic=".$_GET['id']."";
$where = "WHERE id";

$cur = (($page * $max) - $max);

$sql = mysql_query("SELECT * FROM `news` ORDER BY `id` DESC") or die(mysql_error());

$getdata = mysql_query("SELECT * FROM news WHERE id ORDER BY id DESC LIMIT $cur, $max");
$counttotal = mysql_query("SELECT * FROM news WHERE id");
$counttotal = mysql_num_rows($counttotal);
?> <center><h1><b>Новини</b></h1></center> <?php

$total_pages = ceil($counttotal / $max);
if(mysql_num_rows($getdata) > 0){

while ($n = mysql_fetch_assoc($sql)){
while($r = mysql_fetch_array($getdata))
{
?>
<div><a href="article.php?topic=<?php echo $n['id']; ?>"><b><?php echo $n['title']; ?></b></a></div><br />

<table>

<tr><td><b>Добавил</b></td><td><i><?php echo $n['user']; ?></i></td></tr>
<tr><td><b>Информация</b></td><td><a href="article.php?topic=<?php echo $n['id']; ?>"><i><?php echo $n['info']; ?></i></a></td></tr>
<tr><td><b>Добавена на</b></td><td><i><?php echo $n['date']; ?></i></td></tr>
<tr><td><b>Преглеждания</b></td><td><i><?php echo $n['num']; ?></i></td></tr>
<?php
if ($_SESSION['name'] == $n['user']) {
?>
<tr><td><b>Опции</b></td><td><a href="settings.php?select=edit&id=<?php echo $id; ?>"><i>Редактирай</i></a> | <a href="settings.php?select=delete&id=<?php echo $id; ?>"><i>Премахни</i></a></td></tr>

<?php
}
?>


</table>


<hr>

<?php
}

?>
<?php
$end ++;
}
}
else
{
echo "Няма добавени новини";
}
?>
</div>
<div align="center">
<?php
if($counttotal > $max){
echo "";
$adjacents = "2";

$page = ($page == 0 ? 1 : $page);
$start = ($page - 1) * $max;

$prev = $page - 1;
$next = $page + 1;
$last = $page - 1;
$lastpage = ceil($counttotal / $max);
$lpm1 = $lastpage - 1;

$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class='pagination'>";
//$pagination .= "<div class='details'>Страница $page от $lastpage</div>";


if ($page > $counter = 1){
$pagination.= "<div><a href='".$plink."&page=1'>Първа</a></div>";
$pagination.= "<div class='prevPage'><a href='".$plink."&page=$last'>«</a></div>";
}else{
$pagination.= "<div><a class='current'>Първа</a></div>";
$pagination.= "<div class='prevPage'><a class='current'>«</a></div>";
}

if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<div><a class='current'>$counter</a></div>";
else
$pagination.= "<div><a href='".$plink."&page=$counter'>$counter</a></div>";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<div><a class='current'>$counter</a></div>";
else
$pagination.= "<div><a href='".$plink."&page=$counter'>$counter</a></div>";
}
$pagination.= "<div class='dot'>...</div>";
$pagination.= "<div><a href='".$plink."&page=$lpm1'>$lpm1</a></div>";
$pagination.= "<div><a href='".$plink."&page=$lastpage'>$lastpage</a></div>";
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<div><a href='".$plink."&page=1'>1</a></div>";
$pagination.= "<div><a href='".$plink."&page=2'>2</a></div>";
$pagination.= "<div class='dot'>...</div>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<div><a class='current'>$counter</a></div>";
else
$pagination.= "<div><a href='".$plink."&page=$counter'>$counter</a></div>";
}
$pagination.= "<div class='dot'>..</div>";
$pagination.= "<div><a href='".$plink."&page=$lpm1'>$lpm1</a></div>";
$pagination.= "<div><a href='".$plink."&page=$lastpage'>$lastpage</a></div>";
}
else
{
$pagination.= "<div><a href='".$plink."&page=1'>1</a></div>";
$pagination.= "<div><a href='".$plink."&page=2'>2</a></div>";
$pagination.= "<div class='dot'>..</div>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<div><a class='current'>$counter</a></div>";
else
$pagination.= "<div><a href='".$plink."&page=$counter'>$counter</a></div>";
}
}
}

if ($page < $counter - 1){
$pagination.= "<div class='nextPage'><a href='".$plink."&page=$next'>»</a></div>";
$pagination.= "<div><a href='".$plink."&page=$lastpage'>Последна</a></div>";
}else{
$pagination.= "<div class='prevPage'><a class='current'>»</a></div>";
$pagination.= "<div><a class='current'>Последна</a></div>";
}


}

$pagination .= "<div class='pagination'><div class='details'></div></div>";
print $pagination;

}
// echo "<b align=\"right\">Общо ".$total_pages." страници по ".$max." клипа на страница</b>";


?>

</body>
</html> :idea: :roll:
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе