Query

<?php
include 'config.php';
include 'htmltop.php';
include 'safe.php';
$query = "SELECT * FROM gebruikers ORDER BY munten DESC LIMIT 10";
$result = mysql_query($query) OR die ("Sorry, we zijn in onderhoud!");
$nrows = mysql_num_rows($result);
echo '<center><h1>Top 10 beste spelers</h1>';
echo '<table cellspacing="15">';
echo '<tr><td><b>Rang:</td>
	<td><b>Naam:</td>
	<td><b>Muntjes:</td>
	<hr></tr>';
for ($i=0;$i<$nrows;$i++)
{
	$n = $i + 1;
	$top = mysql_fetch_array($result);
	extract($top);
	echo "<tr>
	<td>$n.</td>\n
	<td>$naam</td>\n
	<td>$munten</td>\n
	</tr>\n";
}
echo "</table>\n";
?>