[ecmsinfo]"select * from phome_4ecms_news where checked=1 order by diggtop desc,id desc limit 10",10,30,0,24,10,0[/ecmsinfo]
這個是頂的排行

[ecmsinfo]"select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10",10,30,0,24,10,0[/ecmsinfo]
這個是點擊的排行。。

大蝦能告訴我具體怎么改嗎！！

因為不按欄目來顯示的話。。只要一上新聞就會出現在排行榜！！

select * from phome_4ecms_news where checked=1 and classid in (欄目id1,id2...,idn) order by diggtop desc,id desc limit 10

謝謝樓上大蝦。。

[ecmsinfo]"select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10",10,30,0,24,10,0[/ecmsinfo]

這個按欄目又怎么寫呢。。我用頂的方式寫輸出無內容了！！謝謝大蝦。。我知道我很煩。。

select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) and classid=欄目id order by onclick desc limit 10