$rank = mysql_query("SELECT * FROM users ORDER by points/10000 DESC");
$sort = $_GET['sortby'];
if($sort == "username")
{
$rank = mysql_query("SELECT * FROM users ORDER by username ASC");
?>
| # |
Username |
Points |
}
elseif($sort == "pointsdesc")
{
$rank = mysql_query("SELECT * FROM users ORDER by points DESC");
?>
| # |
Username |
Points |
}
elseif($sort == "pointsdesc")
{
$rank = mysql_query("SELECT * FROM users ORDER by username DESC");
?>
| # |
Username |
Points |
}
elseif($sort == "pointsasc")
{
$rank = mysql_query("SELECT * FROM users ORDER by points ASC");
?>
| # |
Username |
Points |
}
else
{
?>
| # |
Username |
Points |
}
while($row = mysql_fetch_assoc($rank))
{
$i ++;
$ranked =$i;
}
?>
|
echo $ranked;
?>
|
echo $row['username'];
?>
|
echo $row['points'];
?>
|
}
?>
require_once("./footer.php");
?>