php - 如何使用 PHP 和 SQL 更改按年份分组的导航的月份顺序

Question

如何使用 PHP 和 SQL 更改按年份分组的导航月份顺序我正在使用 SQL 为按年份分组的 WordPress 帖子制作导航。我的代码正在运行，但我想更改如下所示的月份顺序。

当前结果

2019　 12 11 10 9 8 7 6 5 4 3 2 1

2018　 12 11 10 9 8 7 6 5 4 3 2 1

我想像这样更改月份的顺序

2019　 1 2 3 4 5 6 7 8 9 10 11 12

2018　 1 2 3 4 5 6 7 8 9 10 11 12

$today = date( 'Y-m-d' );
$year_prev = null;
$months = $wpdb->get_results("SELECT DISTINCT MONTH( post_date ) AS month,
    YEAR( post_date ) AS year,
    COUNT( id ) as post_count FROM $wpdb->posts
    WHERE post_status = 'publish' and post_date <= now( )
    and post_type = 'post'
    GROUP BY month , year
    ORDER BY post_date DESC");
foreach($months as $month) :
$year_current = $month->year;
if ($year_current != $year_prev){
if ($year_prev != null){?>
</ul>
<?php } ?>
<?php echo $month->year; ?>
<ul>
<?php } ?>
    <li><a href="/archive/<?php echo $month->year; ?>/<?php echo date("m", mktime(0, 0, 0, $month->month, 1, $month->year)) ?>"><?php echo date("n", mktime(0, 0, 0, $month->month, 1, $month->year)) ?></a></li>
<?php $year_prev = $year_current;
endforeach; ?>
</ul>

Answer 1

感谢评论，它通过使用“ORDER BYyear DESC，month ASC”代替“ORDER BY post_date DESC”来工作。