order by

Dobrý den mám na stránce tento kod

<br>
<div style="padding-left:20px;" align="left";>
<table width="50%" style="border:1px solid black; background-color: #2b8743; color: black;">
<td align="left" class="title" width="20%"><font color="white">&nbsp;&nbsp;Name:</font></td>
<td align="left" class="title" width="20%"><font color="white">Place:</font></td>
<td align="left" class="title" width="60%" align="center"><font color="white">Points:</font></td>

<?php
$result=mysql_query("SELECT * FROM hraci ORDER BY points");
while($row=mysql_fetch_object($result))
{
echo '

<tr>
<td align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-</td>
<td align="left"><b>' . $row->name . '</b></a></td>
<td align="left">' . $row->points . '</td>

';
}
?>

</table>
</div>
<br><br><br>

a rad bych se zeptal proc mi nefunguje razeni / order by points .. nebo jestli by to neslo udelat tak aby to radil rovnou server dekuji :)

jo dekuju moc bylo to tim :)

jeste bych se rad zeptal (nechci zakladat nove tema)
kdyz mam

<?php
$result=mysql_query("SELECT * FROM hraci ORDER BY points DESC");
$poradi=0;
while($row=mysql_fetch_object($result))

{
echo '

<tr ' if ($poradi>18) echo "class=\"pondeli\"";'>
<td align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;' . $poradi=$poradi+1 . '</td>
<td align="left"><b>' . $row->name . '</b></a></td>
<td align="left">' . $row->points . '</td>

';
}
?>

tak mi to hazi chybu na radku jak je <tr ' if ($poradi>18) echo "class=\"pondeli\"";'> jak to ma byt spravne? ja vim ze to sou zaklady mno a taky se stydim : D

dekuji moc uz to frci .)