Question

【已解决】求助 万能标签sql查询 多栏目？

【已解决】求助 万能标签sql查询 多栏目？ 困扰了1天了， [ecmsinfo]"select * from phome_ecms_news where classid=25 and classid=26 and classid=27 and classid=28 and isgood=0 and ztid like '%|8|' order by id desc limit 10",10,50,0,24,20,0[/ecmsinfo]这样写肯定不对。请问1，怎么调用多栏目？ ztid like '%|8|' 这里能否判断当前专题的ID，怎么写？谢谢哦~

若以下回答无法解决问题，邀请你更新回答

Answer 1

[ecmsinfo]"select * from phome_ecms_news where classid in (25,26,27,28) and isgood=0 and ztid like '%|".$GLOBALS[navclassid]."|%' order by id desc limit 10",10,50,0,24,20,0[/ecmsinfo] 查看原帖>>