php - 如何使用 PHP MYSQL 显示类似于时间线的基于发布日期的数据

Question

请帮助我，我真的遇到了很大的问题。我想在各自的发布日期下显示帖子(文章)。

例如，

NOVEMBER 05
* Post 1
* Post 2
* Post 3

NOVEMBER 04
* Post 1
* Post 2

我写了一段 PHP 代码，但它重复了两次日期和值，例如:

NOVEMBER 05
* Post 1
* Post 2
* Post 3
NOVEMBER 05
* Post 1
* Post 2
* Post 3

NOVEMBER 04
* Post 1
* Post 2

NOVEMBER 04
* Post 1
* Post 2

请帮帮我!

这是我的代码:

      <?php
    include("db.php");
    include("function.php");
    $result=mysqli_query($con,"select distinct post_submitted_on from posts order by id desc");
    while($row=mysqli_fetch_array($result)){
    $datetime=$row['post_submitted_on']; //2016-11-05 23:10:45
    $date=date("d",strtotime($datetime)); //05
    $month=date("F",strtotime($datetime)); //November
    $final_date=date("Y-m-d",strtotime($datetime)); //2016-11-05
  ?>
      <h4 class="date">
        <i style="vertical-align: baseline;" class="fa fa-calendar-o date"></i> <B class="date">TODAY, <?php echo strtoupper($month);?> <?php echo ordinal("$date");?></B> <!-- prints TODAY, NOVEMBER 05 -->
      </h4>
      <?php
        $sql=mysqli_query($con,"select distinct * from posts where post_date='$final_date' order by id desc"); //selecting all posts based on the current date and load all past entries based on past date
        while($r=mysqli_fetch_array($sql)){
      ?>
      <table width="100%" class="hidden-sm hidden-xs">
        <tr>
          <td>
            <?php echo $r['title'];?>
            <?php echo $r['url'];?>
          </td>
        </tr>
      </table>
    <?php } ?>
  <?php } ?>

Answer 1

我只是将其作为社区 Wiki 发布，因为我自己在评论中提到了它并且是该问题的解决方案。

• 将 GROUP BY col 添加到您的查询中，因为使用 DISTINCT 并不总能完成这项工作。

请参阅 Stack 上有关此类行为的以下问答:

• > Why my mysql DISTINCT doesn't work?
• > MySQL select distinct doesn't work
-