Код за странициране

smileface

Registered
Някой може ли да направи този код да се страницира когато има повече от 2 резултати ?
Код:
<?php
$query = mysql_query("SELECT * FROM `comment` WHERE `article`='$id'") or die(mysql_error());
while($raw = mysql_fetch_array($query)){
echo "
<tr>
<td class=\"comment\" style=\"border-bottom: 0px solid #000000\">Дата:  $raw[date] | От: <span class=\"style2\">$raw[author]</span><br>
$raw[comment]</td>
</tr>";
}
?>
 
PHP:
<?php 
include "conf.php";
$broinastranica = 5;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query("SELECT * FROM `comment` WHERE `article`='$id'") or die(mysql_error());
while($raw = mysql_fetch_array($query)){
echo "
<tr>
<td class=\"comment\" style=\"border-bottom: 0px solid #000000\">Дата:  $raw[date] | От: <span class=\"style2\">$raw[author]</span><br>
$raw[comment]</td>
</tr>";
}
$query = "SELECT COUNT(id) AS broi FROM comment"; 
$result = mysql_query($query); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= " $page "; 
} 
else 
{ 
$nomeranastranici .= " <a  href=\"$self?page=$page\" >$page</a> "; 
} 
} 
if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = " <a href=\"$self?page=$page\"><img src=\"images/prev_icon.gif\" border=\"0\" /></a> "; 
$parva = " <a  href=\"$self?page=1\">[първа]</a> "; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 
if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = " <a  href=\"$self?page=$page\"><img src=\"images/next_icon.gif\" border=\"0\" /></a> "; 
$posledna = " <a  href=\"$self?page=$maxPage\">[последна]</a> "; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 
echo "<br>Страницa:  ".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>
 

Back
Горе