Stadig problemmer med loop

<?PHP
$query = mysql_query("SELECT * FROM leagues ORDER BY leagueid") or die(mysql_error());
while($row = mysql_fetch_array($query)) {
    echo '
        <tr>
        <td valign="top" align="center" width="100" height="100%">'.$row['leaguename'].'</td>
        <td valign="top" align="center" width="100" height="100%">'.$row['country'].'</td>
        <td valign="top" align="center" width="100" height="100%">'.$row['leagueid'].'</td>
        <td valign="top" align="center" width="100" height="100%"><a href="fixture.php?leagueid='.$row['leagueid'].'">Make Fixture</a></td>
        </tr>';
}
?>

Det er hvad den udskriver nu

'.$row['country'].' '.$row['leagueid'].' Make Fixture
'; } ?>

Det ser mærkeligt ud. Prøv evt. sådan her:

<?PHP
$query = mysql_query("SELECT * FROM leagues ORDER BY leagueid") or die(mysql_error());
while($row = mysql_fetch_array($query)) {
?>
        <tr>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['leaguename']?></td>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['country']?></td>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['leagueid']?></td>
        <td valign="top" align="center" width="100" height="100%"><a href="fixture.php?leagueid=<?php echo $row['leagueid']?>">Make Fixture</a></td>
        </tr>
<?PHP
}
?>

Nu viser den ikke noget så det er vel lidt positivt :)

Jeg har brugt den her til at connect.

<?php
$link = mysql_connect("mysql5.wannafind.dk", "hemmeligt", "2324451315")
  or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("hemmeligt_dk_db") or die("Could not select database");
?>

min leagues tabel inden holder.
leagueid(bigint)(not null)(primær)(auto increse)
leaguename(text)(not null)
countryid(bigint)(not null)
countryname(text)(not null)
team1(bigint) (null)
team2(bigint) (null)
team3(bigint) (null)
team4(bigint) (null)
team5(bigint) (null)
team6(bigint) (null)
team7(bigint) (null)
team8(bigint) (null)
team9(bigint) (null)
team10(bigint) (null)
team11(bigint) (null)
team12(bigint) (null)

også selvfølgelig..

<?PHP
$query = mysql_query("SELECT * FROM leagues ORDER BY leagueid") or die(mysql_error());
while($row = mysql_fetch_array($query)) {
?>
        <tr>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['leaguename']?></td>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['countryname']?></td>
        <td valign="top" align="center" width="100" height="100%"><?php echo $row['leagueid']?></td>
        <td valign="top" align="center" width="100" height="100%"><a href="fixture.php?leagueid=<?php echo $row['leagueid']?>">Make Fixture</a></td>
        </tr>
<?PHP
}
?>

Og jeg fatter bare ikke hvorfor den ikke gider ud med det :)