Subselect in einer MYSQL Abfrage

[Sumy]

Also ich habe folgenendes vor:

<?php
    $db = mysql_connect("localhost", "XXX", "XXX");
    $res = mysql_db_query("dol",
          "select Name, RealmLevel,(select guildname from guild where guildid=dolcharacters.guildid), RealmPoints, Class, Realm from dolcharacters where RealmLevel > 35 AND RealmLevel < 140 order by RealmPoints desc limit 0,10");

mysql_close($db);

while ($data=mysql_fetch_array($res))
{
  echo "<center>";
  echo "<table width=900>";
  echo "<td width=150>";
  if ($data["Realm"] == 1)
  echo "Albion";
  elseif ($data["Realm"] == 2)
  echo "Midgard";
  elseif ($data["Realm"] == 3)
  echo "Hibernia";
  echo "</td>";
  echo "<td width=150>";
  echo $data["Name"];
  echo "</td>";
  echo "<td width=150>";
  echo $data["Guildname"];
  echo "</td>";
  echo "<td width=150>";
  echo $data["RealmPoints"];
  echo "</td>";
  echo "<td width=150>";
                if ($data["RealmLevel"] == 43)
  echo "5L3";
                echo "</td>";
  echo "<td width=180>";
  if ($data["Class"] == 10)
  echo "Friar";
             echo "</TD></TABLE>";
             echo "</center>";
  }

?>

allerdings irgendwie funzt es net so wie ich will es wir alles ausgegeben ausser der guild sache und das ist eigentlich das wichtige daran, kann mir vlt irgendwer meinen Fehler sagen?