 |
 |
Puck: Hall of Fame
Pos. |
Nickname |
Score |
Ducks |
Efficiency |
$spojeni=mysql_connect("192.168.1.7","combatpillows_com","zsyz0595");
$spojenidb=mysql_select_db("combatpillows_com");
if (!$spojeni)
{
echo"Nepodarilo se navazat spojeni se serverem.";
exit;
}
$query = MySQL_Query("SELECT * FROM players ORDER BY score DESC");
//$query = MySQL_Query("SELECT * FROM Players WHERE nick='".$nick."' AND score='".$score."'");
if (!$query){ echo "Neco je spatne";};
//if(mysql_fetch_array($query,MYSQL_BOTH)) { echo "Dany hrac existuje";} else {echo "Hrac nebyl nalezen.";}
$poradi = 0;
while ($zaznam=mysql_fetch_array($query,MYSQL_BOTH)):
$poradi++;
if ($poradi<=3) {
echo("
$poradi |
".$zaznam["nick"]." |
".$zaznam["score"]." |
".$zaznam["gooses"]." |
".$zaznam["efficiency"]."% |
");
}
else {
echo("
$poradi |
".$zaznam["nick"]." |
".$zaznam["score"]." |
".$zaznam["gooses"]." |
".$zaznam["efficiency"]."% |
");
}
endwhile;
?>
|
|
|
|