php - 计算当月 PHP 中的 MySQL 行数

Question

我想显示当月的订单数，但我不知道执行此操作的查询:

这是代码:

$stats_orders_curr = mysql_query(
                     'SELECT count(1) FROM orders 
                      WHERE MONTH = MONTH(CURDATE()) 
                      AND YEAR = YEAR(CURDATE())'
);

$orders_curr =  mysql_fetch_array($stats_orders_curr);
$orderscurr = $orders_curr[0];

Answer 1

我会改变 SQL

SELECT count(1) FROM orders WHERE MONTH = MONTH(CURDATE()) AND YEAR = YEAR(CURDATE())

到

SELECT count(*) FROM `orders` WHERE MONTH(`orderdate`) = MONTH(CURDATE()) AND YEAR(`orderdate`) = YEAR(CURDATE())

其中orderdate是记录订单日期的字段;)