如何在PHP / mysql中按升序显示月份？ [英] How to show month in ascending order in PHP/mysql ?

问题描述

我想打印按日期按升序添加的用户列表，但是有一个月订单的问题，我使用的是dd-mm-yy日期格式



我尝试过：

i want to print a list of users added by date in ascending order, but there is an issue of month order, i am using dd-mm-yy date format

What I have tried:

$query="SELECT * FROM `transactions` WHERE `dealer_id` = '$dealer_id' ORDER BY `_date` ASC";

推荐答案

query = SELECT * FROM` transactions `WHERE`chavers_id` ='

query="SELECT * FROM `transactions` WHERE `dealer_id` = '

dealer_id'ORDER BY`_date`ASC;

dealer_id' ORDER BY `_date` ASC";

这篇关于如何在PHP / mysql中按升序显示月份？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！