我的问题是:
SELECT MAX(num)
FROM (SELECT nomInteretUser,idUser,COUNT(nomInteretUser) as num
FROM userInteret
WHERE nomInteretUser IN ('piano','flute','chien') GROUP BY idUser
)
目标是将IN ('piano','flute','chien')
更改为动态数组,如
SELECT nomInteretUser, idUser, COUNT(nomInteretUser) as num
FROM userInteret
WHERE nomInteretUser IN ($array)
GROUP BY idUser
注:$array是一个包含互联网络列表的数组
发布于 2016-05-05 12:04:12
使用implode()
。试试下面的代码。您需要将数组转换为字符串。因此,在这里,我们将用逗号将其内爆,用','
字符串等引号分隔,并在查询中使用。
$array =array('piano','flute','chien');
$string = implode("','", $array);
$query = "SELECT nomInteretUser, idUser, COUNT(nomInteretUser) as num
FROM userInteret
WHERE nomInteretUser IN ('".$string."')
GROUP BY idUser";
查看在线演示: 单击此处
https://stackoverflow.com/questions/37050057
复制相似问题