Hallo ich habe mit einem kumpel (wombat1111) ein pvp script geschreiben das die spieler personalwertung... angezeigt wird aber ich bekomm einfach net hin das das script die werte nach personalwertung sortieren soll -.-

hier mal das script:

<?php include("conf2.php");
$connect = mysql_connect($host, $user, $pass) or die ("Can't connect");
mysql_select_db($characters, $connect);
$sql = "SELECT arenateamid FROM arena_team_stats";
$result = mysql_query($sql, $connect);
$i=0;

echo "<p align='center'>$img</p>";
echo "<table width=70% cellpadding=3 align=center><tr>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Spieler&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Arenateam&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Typ&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Wertung&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Spiele&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Gewonnenen&nbsp;&nbsp;&nbsp;</font></b></td>
<td><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b><center>&nbsp;&nbsp;&nbsp;Fraktion&nbsp;&nbsp;&nbsp;</font></center></b></td></tr>";

while ($vystup = mysql_fetch_array($result))
{
$sql2 = "SELECT arenaTeamId, name, captainGuid, type, seasonGames, seasonWins FROM arena_team WHERE arenaTeamId = ".$vystup['arenateamid']."";
$query2 = mysql_query($sql2);
$fetch2 = mysql_fetch_assoc($query2);
$sql3 = "SELECT arenaTeamId, guid, personalRating, seasonGames, seasonWins FROM arena_team_member WHERE arenaTeamId = ".$vystup['arenateamid']."";
$query3 = mysql_query($sql3);
$fetch3 = mysql_fetch_assoc($query3);
$sql4 = "SELECT name, race FROM characters WHERE guid = ".$fetch3['guid']."";
$query4 = mysql_query($sql4);
$fetch4 = mysql_fetch_assoc($query4);
$i=$i+1;
echo "<tr>";


if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;&nbsp; ".$fetch4['name']."&nbsp;&nbsp;</font></span></td>";}
if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;&nbsp; ".$fetch2["name"]."&nbsp;&nbsp;</b></font></span></td>";}
if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;2 vs 2&nbsp;</font></span></td>";}
if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;&nbsp; ".$fetch3["personalRating"]."&nbsp;&nbsp;</b></font></span></td>";}
if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;&nbsp; ".$fetch3["seasonGames"]."&nbsp;&nbsp;</b></font></span></td>";}
if ($fetch2["type"]==2)
{ print "<td align='center'><span style='color: #0066CC;'><FONT 10pt tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif><b>&nbsp;&nbsp; ".$fetch3["seasonWins"]."&nbsp;&nbsp;</b></font></span></td>";}
if ($fetch4["race"]==1 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/a.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==2 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/h.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==3 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/a.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==4 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/a.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==5 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/h.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==6 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/h.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==7 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/a.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==8 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/h.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==10 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/h.png' width='32' height='32' /></td>";}
elseif ($fetch4["race"]==11 and $fetch2["type"]==2)
{ print "<td align='center'><img src='img/a.png' width='32' height='32' /></td>";}
echo "</tr>";
}
mysql_close();
echo "</table></th>";
?>
</body>
</html>

habe ich schon ausprobiert geht noch immer nicht -.-

gibt es noch andere php befehle das es nach personalrating sortiert oder nur den einen?

niemand hat eine lösung?