select sum(huahui_shops_products.price) as prices from huahui_shops_orders,huahui_shops_products where huahui_shops_products.oid=huahui_shops_orders.oid group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%d") ; #把时间戳转换成月份 其他细节。你自己再补充哈
group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%c")%d 改成 %c哈。刚搞错了d是 日 c才是月
select sum(huahui_shops_products.price) as prices
from huahui_shops_orders,huahui_shops_products
where huahui_shops_products.oid=huahui_shops_orders.oid
group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%d") ; #把时间戳转换成月份
其他细节。你自己再补充哈
group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%c")%d 改成 %c哈。刚搞错了d是 日
c才是月