php - 如何在随机选择中停止mysqli重复

Question

我有一个查询选择由用户随机创建的帖子，这些帖子的浏览量大于 1 且不超过 2 周，效果很好，但我注意到 1 个或 2 个或更多帖子有重复。我尝试 GROUP BY id 但仍然遇到同样的问题。以下是查询；

// the two variables work together with a Jquery load more am using to add 15 more posts on page scroll
$start = 0;
$limit = 15;

$query = "SELECT * FROM posts WHERE views > 1 AND date_created >= SUBDATE(NOW(), INTERVAL 2 WEEK) ORDER BY RAND() LIMIT ".$start.", ".$limit;
$stmt = mysqli_prepare($database, $query);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    // echo posts
}

如何使查询随机获取所有帖子而不重复任何帖子（这是由 引起的ORDER BY RAND()）

标签： phpmysqli