Code: Select all
echo '<table cellpadding="0" cellspacing="0">';
$result = mysql_query('SELECT AVG(oak_listen.Point) AS Sum, Navn FROM oak_listen GROUP BY SpillerID ORDER BY Sum DESC');
$i = 1;
while ($row = mysql_fetch_assoc($result)) {
echo '<tr>';
echo '<td width="5%" align="left" valign="middle">' . $i . '</td>';
echo '<td align="left" valign="middle">' . $row['Navn'] . '</td>';
echo '<td align="left" valign="middle">' . number_format($row['Sum'], 3) . '</td>';
echo '</tr>';
$i++;
}
echo '</table>';