<?

$pseudonym=$_POST['pseudonym'];
$pass=$_POST['pass'];
$punkte=$_POST['punkte'];

if ($pseudonym && $pass){
	mysql_pconnect("localhost","www","www") or die ("didn't connect to mysql");
	mysql_select_db("www") or die ("no database");
$query = "SELECT * FROM game WHERE pseudonym = '$pseudonym' AND pass = '$pass'";
$result = mysql_query( $query ) or die ("didn't query");

$num = mysql_num_rows( $result );
if ($num == 1){
	$sql = "UPDATE game SET punkte = '$punkte' WHERE pseudonym = '$pseudonym'";	
  	$result = mysql_query($mysql_pconnect, $mysql_select_db) or trigger_error("SQL", E_USER_ERROR);
	print "status=You're in&checklog=1";
	} else {
	print "status=Sorry, but your user name and password did not match a user name/password combination in our database.  Usernames and passwords are entered in from a different file.  Thank you for visiting test login script!!&checklog=2";
}
}

?>

$result = mysql_query($sql) or die('...');

<?
//connect to database
mysql_pconnect("localhost","www","www") or die ("didn't connect to mysql");
mysql_select_db("www") or die ("no database");
	
mysql_query("SET NAMES 'UTF8'");  

// Gibt die aktuelle Rangliste mit Namen aus.
$result = mysql_query("SELECT * FROM game ORDER BY punkte DESC") 
or die(mysql_error());  


echo "<table border='1'>";
echo "<tr> <th>Pseudonym</th> <th>Punkte</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['pseudonym'];
	echo "</td><td>"; 
	echo $row['punkte'];
	echo "</td></tr>"; 
} 

echo "</table>";

?>

$rang = 1;
echo "<table border='1'>";
echo "<tr> <th>userid</th> <th>Pseudonym</th> <th>Punkte</th> <th>Rang</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $rang;
    echo "</td><td>"; 
    echo $row['pseudonym'];
    echo "</td><td>"; 
    echo $row['punkte'];
    echo "</td><td>";
	echo "$rang";
	echo "</td></tr>"; 

    $rang++;
}