

Seřazení výpisu z DB
Dobrý den, potřebuji poradit se seřazením výpisu z db. Nevím si vůbec rady. Zde je script:
<?php
include 'config.php';
session_start();
if (isset($_SESSION['player']) && !empty($_SESSION['player'])) {
$player = mysql_real_escape_string($_SESSION['player']);
$playerinfo = "SELECT * FROM uzivatele WHERE jmeno = '$player'";
$playerinfo2 = mysql_query($playerinfo) or die("Nelze!");
$playerinfo3 = mysql_fetch_array($playerinfo2);
echo "
<center>
<a href='index.php'><div id='buttonf'></div></a>
<a href='pruzkum.php'><div id='buttonn'></div></a>
<a href='arena.php'><div id='buttoni'></div></a>
<a href='prace.php'><div id='buttono'></div></a>
<a href='obchodzbrane.php'><div id='buttong'></div></a>
<a href='obchodvyzbroj.php'><div id='buttonh'></div></a>
<br><br>
<a href='premium.php'><div id='buttonk'></div></a>
<a href='posta.php'><div id='buttonl'></div></a>
<a href='kralovstvi.php'><div id='buttonm'></div></a>
<a href='sinslavy.php'><div id='buttonj'></div></a>
<a href='odhlaseni.php'><div id='buttond'></div></a>
<a href='nastaveni.php'><div id='buttone'></div></a>
</center>
";
} else {
echo "
<center>
<a href='index.php'><div id='buttons'></div></a>
<a href='registrace.php'><div id='buttona'></div></a>
<a href='prihlaseni.php'><div id='buttonb'></div></a>
<a href='###'><div id='buttonc'></div></a></center>
";
};
?>
<?php
include 'config.php';
if (isset($_SESSION['player']) && !empty($_SESSION['player'])) {
$player = mysql_real_escape_string($_SESSION['player']);
$playerinfo = "SELECT * FROM uzivatele WHERE jmeno = '$player'";
$playerinfo2 = mysql_query($playerinfo) or die("Nelze!");
$playerinfo3 = mysql_fetch_array($playerinfo2);
$hraci = mysql_query("select * from uzivatele");
while ($hraciinfo = mysql_fetch_array($hraci));
echo "
<center>
<div id='arenaspec'>
<br>
<font face='Armor'>
<h3>Aréna</h3></font>
<center>
<div id='tabarena'>
<br>
<table align='center' border='1px'>
<tr>
<td>#</td><td>Pozice</td><td>Jméno</td><td>Úroveň</td>
</tr>
<tr>
<td>" . $hraciinfo['id'] . " </td><td>" . $hraciinfo['pozice'] . " </td><td><a href='index.php?hrac=" . $hraciinfo['jmeno'] . "'> " . $hraciinfo['jmeno'] . "</td><td> " . $hraciinfo['uroven'] . "</td>
</tr>
<tr>
<td>" . $playerinfo3['id'] . " </td><td>" . $playerinfo3['pozice'] . " </td><td><a href='index.php?hrac=" . $playerinfo3['jmeno'] . "'> " . $playerinfo3['jmeno'] . "</td><td> " . $playerinfo3['uroven'] . "</td>
</tr>
<tr>
<td>" . $playerinfo3['id'] . " </td><td>" . $playerinfo3['pozice'] . " </td><td><a href='index.php?hrac=" . $playerinfo3['jmeno'] . "'> " . $playerinfo3['jmeno'] . "</td><td> " . $playerinfo3['uroven'] . "</td>
</tr>
<tr>
<td>" . $playerinfo3['id'] . " </td><td>" . $playerinfo3['pozice'] . " </td><td><a href='index.php?hrac=" . $playerinfo3['jmeno'] . "'> " . $playerinfo3['jmeno'] . "</td><td> " . $playerinfo3['uroven'] . "</td>
</tr>
<tr>
<td>" . $playerinfo3['id'] . " </td><td>" . $playerinfo3['pozice'] . " </td><td>" . $playerinfo3['jmeno'] . "</td><td> " . $playerinfo3['uroven'] . "</td>
</tr>
</table>
</div>
Tak proč upravuješ PHP skripty, když to neumíš?
Seřadit výpis? A podle čeho? Nastuduj si klauzuli ORDER BY příkazu SELECT.
SELECT * FROM uzivatele WHERE jmeno = '$player' ORDER BY pozice
Jo díky :D To mně fakt nenapadlo :D Díky moc.