PHP код за класация

[XxLPxX]

<?php
echo'<div id="con-right">
<div class="top-right">'.TITLE_CENTER_RATING.'</div>
<div id="center-right">';
$page = (int) $_GET['page'];

$max= "8";

$end = $page+$max;
$sql="SELECT * FROM `users` LIMIT $page,$end ";
$result=mysql_query($sql);


while($sha=mysql_fetch_assoc($result))
{

echo '<table border=0 style="border-collapse:collapse;float:left;margin-left:15px;margin-top:15px;" cellspacing="0"><tr><td style="width:100px;height:100px;"><a href="view.php?user='.$sha['user'].'"><img src="'.$sha['avatar'].'" width=100 height=100 border=0 alt=""/></a></td><tr><td align="center" style="width:100px;height:20px;line-height:10px;"><b>'.$sha['user'].'</b></td></tr><table>';

}

$next = $end+1;

$prev = $page-1;

echo "<a href=\"rating.php?page=".$next."\">следваща</a>";
echo "<a href=\"rating.php?page=".$prev."\">предишна</a>";


echo'</table><br/><br/>';
echo'</div>
<div class="bottom-right"></div>
<div class="banner"></div>
</div>
</div>
</div>';
?>

Опитах се да си напиша код за странициране , всичко е ок ама нещо не работят бутоните следваща и предошна :S

 

[stoqnski]

<?php
echo'<div id="con-right">
<div class="top-right">'.TITLE_CENTER_RATING.'</div>
<div id="center-right">';
$page = (int) $_GET['page'];

$max= "8";

$end = $page+$max;
$sql="SELECT * FROM `users` LIMIT $page,$end ";
$result=mysql_query($sql);


while($sha=mysql_fetch_assoc($result))
{

echo '<table border=0 style="border-collapse:collapse;float:left;margin-left:15px;margin-top:15px;" cellspacing="0"><tr><td style="width:100px;height:100px;"><a href="view.php?user='.$sha['user'].'"><img src="'.$sha['avatar'].'" width=100 height=100 border=0 alt=""/></a></td><tr><td align="center" style="width:100px;height:20px;line-height:10px;"><b>'.$sha['user'].'</b></td></tr><table>';

}

$next = $end+1;

$prev = $page-1;

echo "<a href=\"rating.php?page=".$next."\">следваща</a>";
echo "<a href=\"rating.php?page=".$prev."\">предишна</a>";


echo'</table><br/><br/>';
echo'</div>
<div class="bottom-right"></div>
<div class="banner"></div>
</div>
</div>
</div>';
?>

тук може да не ти се съвпада Ако файла за класацията ти се казва top.php там тряя стане top.php?page= ...