Вывод из БД

<IMG SRC='$img_server/i/klan/".$clan.".gif'<b> $com_name</b></a>

        $clan = mysql_query("select tribe from players where user='".$com_name."'");

$query = mysql_query("select tribe from players where user='$com_name'");
if (mysql_num_rows($query)) $result = mysql_fetch_assoc($query);
$clan = $result['clan'];

$query2 = mysql_query("select tribe from players where user='$user_name'");

        $result = $db->sql_query("SELECT a.id, a.cid, a.date, a.uid, a.name, a.host_name, a.comment, b.user_name, b.user_email, b.user_website, b.user_avatar, b.user_regdate, b.user_icq, b.user_sig, b.user_viewemail, b.user_aim, b.user_yim, b.user_msnm FROM ".$prefix."_comment AS a LEFT JOIN ".$prefix."_users AS b ON (a.uid=b.user_id) WHERE cid='$cid' AND modul='$module_name' ORDER BY date DESC LIMIT $offset, $comnum");

OpenTable();
        echo "<center><font class=\"option\">"._COMMENTS."</font></center><br />";
        if ($pagenum == "") $pagenum = 1;
        $offset = ($pagenum - 1) * $comnum;
        $numpages = ceil($numstories / $comnum);
        $a = $numstories;
        if ($numstories > $offset) $a -= $offset;
        $offset = intval($offset);
        $comnum = intval($comnum);
        $result = $db->sql_query("SELECT a.id, a.cid, a.date, a.uid, a.name, a.host_name, a.comment, b.user_name, b.user_email, b.user_website, b.user_avatar, b.user_regdate, b.user_icq, b.user_sig, b.user_viewemail, b.user_aim, b.user_yim, b.user_msnm FROM ".$prefix."_comment AS a LEFT JOIN ".$prefix."_users AS b ON (a.uid=b.user_id) WHERE cid='$cid' AND modul='$module_name' ORDER BY date DESC LIMIT $offset, $comnum");
        $query2 = mysql_query("select tribe from players where user='$user_name'");
        if (mysql_num_rows($query2)) $result2 = mysql_fetch_assoc($query2);
        $clan = $result2['clan'];
 
        while (list($id, $c_cid, $send_date, $sender_id, $sender_name, $sender_host, $com_text, $user_name, $user_email, $user_website, $user_avatar, $user_regdate, $sender_icq, $user_sig, $user_viewemail, $sender_aim, $sender_yim, $sender_msn) = $db->sql_fetchrow($result)) {
            $com_name = ($user_name) ? $user_name : (($sender_name) ? $sender_name : $anonymous);
            $avatar = ($user_avatar && file_exists("".$adirectory."/".$user_avatar."")) ? "<img src=\"".$adirectory."/".$user_avatar."\" align=\"left\" alt=\"$com_name\" title=\"$com_name\" />" : "<img src=\"".$adirectory."/00.gif\" align=\"left\" alt=\"$com_name\" title=\"$com_name\" />";
            preg_match("/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/", $user_regdate, $datetime);
            $user_regdate = ($user_regdate) ? "".$datetime[3].".".$datetime[2].".".$datetime[1]."" : "<i>"._NO_INFO."</i>";
            $text = ($user_sig) ? "".bb_decode($com_text)."<hr>".bb_decode($user_sig)."" : "".bb_decode($com_text)."";
            $user_point = ($user_points) ? ""._POINTS.": ".$user_points."" : "";
            $name = "<a href=\"javascript: InsertCode('name', '".$com_name."', '', '', 'area')\">
 
                <IMG SRC='/img/i/klan/".$clan.".gif'<b> $com_name</b></a>
                <a href=\"inf.php?login=$com_name\" target=\"_blank\" title=\""._PERSONALINFO."\"><img border=\"0\" src=\"img/i/inf.gif\"></a> ";
 
            $info = "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"left\">".$user_point."</td><td align=\"right\">"._DATE.": ".formatTimestamp($send_date)." | "._COMMENT.": $a</td></tr></table>";
            $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td align=\"left\">"._REG_DATE.": ".$user_regdate."</td><td align=\"right\">";
 
            $link .= ((is_admin($admin) || $user_viewemail == 1) && $user_email) ? "<a href=\"mailto:$user_email\" title=\"$user_email\"><img border=\"0\" src=\"images/blocks/Contact.gif\" width=\"16\" height=\"16\"></a> " : "";
            if (is_admin($admin)) {
                $link .= "<a href=\"".$admin_file.".php?op=SecurityBlocker&new_ip=$sender_host\" title=\""._BANIPSENDER."\"><img border=\"0\" src=\"images/blocks/Close.gif\" width=\"16\" height=\"16\"></a> <a href=\"".$admin_file.".php?op=DeleteComments&id=$id&cid=$c_cid&module_name=$module_name&com_text=".htmlspecialchars($com_text)."\" title=\""._DELETE."\"><img border=\"0\" src=\"images/delete.gif\" width=\"16\" height=\"16\"></a> <a href=\"".$admin_file.".php?op=EditComments&id=$id\" title=\""._EDIT."\"><img border=\"0\" src=\"images/edit.gif\" width=\"16\" height=\"16\"></a> "
                ."<a href=\"http://www.dnsstuff.com/tools/whois.ch?ip=".$sender_host."\" title=\""._IP.": $sender_host\" target=\"_blank\"><img border=\"0\" src=\"images/help.gif\" width=\"16\" height=\"16\"></a>";
            }
            $link .= "</td></tr></table>";
            comment($com_id, $name, $info, $avatar, $text, $rate, $link);
            $a--;
        }
        CloseTable();

$result2[0]['clan']

die(print_r($query2));

die(print_r($result));

die(print_r(mysql_fetch_assoc($query2)));

$result = mysql_fetch_assoc($query2); die(print_r($result));

die(print_r($result2));

select tribe from players where user=''1

die(print_r($db->sql_fetchrow($result2)));

die(print_r($result2));

die(print_r($db->sql_fetchrow($result2)));

$result2 = $db->sql_query("select tribe from players where user='$user_name'");
list($tribe) = $db->sql_fetchrow($result2);
die(print_r($tribe));