php - 帖子存档不显示年份和月份

Question

我是php和mysql的新手。我试图将数据库中的帖子显示为月份和年份，并计算一个月内的帖子总数。我的代码在这里...

<?php 
    $sql="SELECT YEAR(FROM_UNIXTIME(post_date)) AS EAR,MONTHNAME(FROM_UNIXTIME(post_date)) AS MONTH, COUNT(*) AS TOTAL from post GROUP BY YEAR, MONTH";
    $result=mysql_query($sql,$bd) or die("Error:".mysql_error());
    while($row=mysql_fetch_array($result)){
        ?>
        <dl>
         <dt><?php echo $row['YEAR']; ?></dt>
         <dd><a href="posts.php?month=<?php echo $row['MONTH']; ?>"><?php echo "&nbsp;&nbsp;&nbsp;&nbsp;".$row['MONTH']."(".$row['TOTAL'].")" ?></a></dd>
        </dl> 
<?php } ?>

但是我没有得到正确的结果，我只能看到小括号和小括号内的帖子总数，例如(7)有人可以帮我吗？

Answer 1

您的查询中有一个拼写错误，EAR 而不是 YEAR。该错误只是告诉您这一点。

<?php 
    $sql="SELECT YEAR(FROM_UNIXTIME(post_date)) AS YEAR,MONTHNAME(FROM_UNIXTIME(post_date)) AS MONTH, COUNT(*) AS TOTAL from post GROUP BY YEAR, MONTH";
    $result=mysql_query($sql,$bd) or die("Error:".mysql_error());
    while($row=mysql_fetch_array($result)){
        ?>
        <dl>
         <dt><?php echo $row['YEAR']; ?></dt>
         <dd><a href="posts.php?month=<?php echo $row['MONTH']; ?>"><?php echo "&nbsp;&nbsp;&nbsp;&nbsp;".$row['MONTH']."(".$row['TOTAL'].")" ?></a></dd>
        </dl> 
<?php } ?>

查看部分:

YEAR(FROM_UNIXTIME(post_date)) AS YEAR

另外，从您的网站来看，href 似乎不正确。试试这个:

<a href="<?php echo 'posts.php?month='.$row['MONTH']; ?>">