<?php
$broinastranica = 19;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT * FROM users ORDER BY respect DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table>";
echo '<tr><td>#</td><td>Гангстер</td><td>Респект</td><td>Ниво</td></tr>';
$br=1;
while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$br.'</td><td><a href='.$path.'='.$row['id'].'>'.$row['username'].'</a></td><td>'.$row['respect'].'</td><td>'.$row['level'].'</td></tr>';
$br=$br+1;
}
echo"</table>";
?>
