PHP & MySQL 查询问题

Question

如何在我的 MySQL 查询中检查每个数组中的每个值。我希望这是有道理的。

SELECT articles_comments.comment_id FROM articles_comments
WHERE articles_comments.comment_id =

Array
(
    [0] => 5
    [1] => 6
    [2] => 10
    [3] => 11
    [4] => 12
    [5] => 17
    [6] => 3
    [7] => 4
    [8] => 7
    [9] => 8
    [10] => 9
    [11] => 16
)

AND articles_comments.user_id = 

Array
(
    [2] => 4
    [3] => 4
    [4] => 4
    [8] => 4
    [9] => 4
    [10] => 4
)

Answer 1

像那样:

$query = "SELECT articles_comments.comment_id FROM articles_comments
WHERE articles_comments.comment_id IN(" . implode(",", $commentArray) . ")
  AND articles_comments.user_id IN(". implode(",", $userArray) . ")";

?