Вече имаме кода за класацията но как да направим така че да вземем стойноста плаце до потребителя ivan напримерно и да я вмъкнем в база данни.
Код:
<html>
<?php include ("conf.php");
if(!isset($_GET['page']))
{
$page = 1;
}
else {
$page = $_GET['page'];
}
$max_results = 5;
if ($page != 1) {
$place = ($page-1)*$max_results;
} else {
$place = 0;
}
$from = (($page * $max_results) - $max_results);
$db = mysql_query("SELECT * FROM users ORDER BY points DESC LIMIT $from,$max_results") or die(mysql_error());
while($row = mysql_fetch_array($db)) {
$place++;
$user = $row['username'];
$points = $row['points'];
echo"$place. $user: $points <br /> ";
}
echo "</table>";
$i++;
if($i > 1) {
echo"</tr><tr>";$i = "0";
}
echo"</tr></table></tr></td></table>";
echo "<br>";
echo "<b>Страници: ";
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM users"),0);
$total_pages = ceil($total_results / $max_results);
if($page > 1){
$prev = ($page - 1);
echo "<a id=\"stranici\" href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>";
}
for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a id=\"stranici1\" href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
}}
if($page < $total_pages){
$next = ($page + 1);
echo "<a id=\"stranici\" href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a></b>";
}
?>