编程之家 jb51.cc
问题:
以下为引用的内容: [ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 2 DAY) order by onclick desc limit 10",10,30,24,7,0[/ecmsinfo] |
这样只能调用全站的信息,我想调用某一栏目48小时内点击最热门的信息怎么写?
回答:
以下为引用的内容: [ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 2 DAY) and classid in (栏目ID,栏目ID) order by onclick desc limit 10",0[/ecmsinfo] |