select count(*) from UserAssessList where userEvaluation =#pingjia# and (to_days(now()))<=(to_days(`Issue_time`)+#shijian#)pingjia为 好,中,差 时间是 6(一周),30(一个月)
select count(*) from UserAssessList where userEvaluation =#pingjia# and (DATEDIFF(day,Issue_time,getdate()) #shijian#) and shop_id=#shop_id# sql server版本的,懒得写这个的,迫于你的压力啊 你上次不是说的吗 别在群里面乱扯 !! 要解决问题! 怕怕啊
select count(*) from UserAssessList where userEvaluation =#pingjia# and (DATEDIFF(day,Issue_time,getdate()))< #shijian# and shop_id=#shop_id#
少了这个
要不怎么知道对哪个商家的评价呢
你上次不是说的吗 别在群里面乱扯
!!
要解决问题!
怕怕啊