sql

SQL标签的应用已带模版的标签为例:[ecmsinfo]select * from phome_ecms_news where newstimeSUBDATE(NOW(),INTERVAL 30 DAY) order by onclick desc limit 10,10,30,0,24,7,0[/ecmsinfo]注意部分：30 是单位(天，当然