means , a page that will show players in pages , it will show gold and points as well , the ranking will be ordered by points.
As well now you can see my page with the list :
http://prntscr.com/q199g
But i can't figure how to make links for users , like a profile link for every user.
something like that : http://www.oryzhon.com/vw/rank.php
Any one could help me with that?
Thats my script :
Code: Select all
<?php
include_once 'connect.php';
session_start();
include_once 'logo.php';
?>
<link href="style.css" rel="stylesheet" type="text/css" />
<?php
if (isset($_SESSION['player']))
{
$player=$_SESSION['player'];
}
else
{
echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
exit;
}
$playerinfo="SELECT * from players where name='$player'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);
include_once 'statpanel.php';
$result = mysql_query("SELECT * FROM players ORDER BY id");
while($row = mysql_fetch_array($result))
{
echo $row['id'];
echo " " . $row['name'];
echo " " . $row['gold'];
echo "<br>";
}
?>