I tried to upload this script but the only thing that was printed on the website was 'BEST OF THE BEST' ? what am I doing wrong?

<?
$username="xxxxxx";
$password="xxxxxx";
$database="indoorsoccerforum_com_au_fivedock";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM BEST OF THE BEST";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

echo "<b><center>BEST OF THE BEST</center></b><br><br>";
$i=0;
while ($i < $num) {
$team=mysql_result($result,$i,"TEAM");
$winpercentage=mysql_result($result,$i,"WIN PERCENTAGE");
$for=mysql_result($result,$i,"For");
$against=mysql_result($result,$i,"Against");

echo "<b>Team: $team</b><br>WIN PERC: $winpercentage<br>FOR: $for<br> AGAINST: $against<br><hr><br>";
$i++;
}
?>

Hmm, i'm pretty sure you can't have spaces in table names, or in field names. Try renaming your table to, for example, "BestOfTheBest".
It's generally a bad idea to use '@', especially when developing, since it will suppress errors and warnings.

I made some small modifications, try this code instead.

PHP Code:

<?
$username="xxxxxx";
$password="xxxxxx";
$database="indoorsoccerforum_com_au_fivedock";
mysql_connect(localhost,$username,$password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
$query="SELECT *  FROM BestOfTheBest";
$result=mysql_query($query) or die(mysql_error());
mysql_close();
 
echo "<b><center>BEST OF THE BEST</center></b><br><br>";
while ($row = mysql_fetch_assoc($result)) {
$team = $row['team'];
$winpercentage = $row['win_perentage'];
$for = $row['for'];
$against = $row['against'];

echo "<b>Team: $team</b><br>WIN PERC: $winpercentage<br>FOR: $for<br> AGAINST: $against<br><hr><br>";
$i++;
}
?>

<?
//MyDB represents the name of your database.
//MyTable represents the name of your table inside the database.
mysql_connect("localhost","","") or die("Unable to connect to SQL server");
@mysql_select_db("MyDB") or die("Unable to select database");
$result = mysql_query("select * from MyTable limit 100");
?>
<table border="1">
<tr>
<?
while ($field=mysql_fetch_field($result)) {
echo "<th>";
echo "$field->name";
echo "</th>";
}
echo "</tr>";
while ($row = mysql_fetch_row($result)) {
echo "<tr>";
for ($i=0; $i<mysql_num_fields($result); $i++) {
echo "<td>";
echo "$row[$i]";
echo "</td>";
}
echo "</tr>\n";
}
echo "</table>";
?>