<?php
$dbhost = 'localhost';
$dbuser = 'dbuser';
$dbpass = 'dbpass';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'dbname';
mysql_select_db($dbname);

$query = "SELECT * FROM challengeus";
$result = mysql_query($query)
or die(mysql_error());
print "
<table border=\"5\" cellpadding=\"5\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#808080\" width=\"100&#37;\" id=\"AutoNumber2\" bgcolor=\"#C0C0C0\"><tr>
<td width=100>Clan:</td>
<td width=100>ClanWebsite:</td>
<td width=100>Number of Players:</td>
<td width=100>Gametype:</td>
<td width=100>Map:</td>
<td width=100>Server:</td>
<td width=100>Date:</td>
<td width=100>Result:</td>
</tr>";

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "<tr>";
print "<td>" . $row['clan'] . "</td>";
print "<td>" . $row['clanwebsite'] . "</td>";
print "<td>" . $row['players'] . v . $row['players'] . "</td>";
print "<td>" . $row['gametype'] . "</td>";
print "<td>" . $row['map'] . "</td>";
print "<td>" . $row['server'] . "</td>";
print "<td>" . $row['date'] . "</td>";
print "<td>" . $row['result'] . "</td>";
print "</tr>";
}
print "</table>";
?>