当我在MySQL查询上使用GROUP_CONCAT时出错

debugcn 发表于 Dev

o6 qr

我的代码运行良好，但是当我添加时

GROUP_CONCAT(CONCAT("<a href='index.php?id=", awards_user.userid, "'>", awards_user.username, "</a>")) AS userlist

获取用户名和用户名的用户ID，告诉我错误

解析错误：语法错误，意外的T_STRING [在此行]

SELECT awards.name as name, awards.link as link, 
       GROUP_CONCAT(DISTINCT awards_user.username) AS username,
       GROUP_CONCAT(DISTINCT awards_user.userid) AS userid,
       GROUP_CONCAT(CONCAT("<a href='index.php?id=", awards_user.userid, "'>", awards_user.username, "</a>")) AS userlist
   FROM awards LEFT JOIN awards_user ON (awards_user.awardid = awards.awardid)
   where awards.forumid = '".$_REQUEST['forumid']."'
   GROUP BY awards.awardid, awards.name, awards.link

钾盐

您应该"使用反斜杠转义双引号，\否则php会将其理解为字符串的结尾：

$sql = "SELECT awards.name as name
             , awards.link as link
             , GROUP_CONCAT(DISTINCT awards_user.username) AS username
             , GROUP_CONCAT(DISTINCT awards_user.userid) AS userid
             , GROUP_CONCAT(CONCAT(\"<a href='index.php?id=\", awards_user.userid, \"'>\"
             , awards_user.username, \"</a>\")) AS userlist
        FROM awards LEFT JOIN awards_user ON (awards_user.awardid = awards.awardid)
        WHERE awards.forumid = '" . $_REQUEST['forumid'] . "'
        GROUP BY awards.awardid
               , awards.name
               , awards.link";

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。