$sql = "
        SELECT
            players.name AS pname
        FROM
            players, friends_refer AS refer
        WHERE
            players.account_name = '".$_SESSION['UserID']."'
        ";
        $result = mysql_query($sql) OR die("<pre>\n".$sql."</pre>\n".mysql_error());
            if($result) {
                while ($row = mysql_fetch_array($result)) {
                    echo '<div>'.$row['pname'].'</div>';
                }
            }