Question

科讯（急急急）如何调用主分类下的子栏目文章

select top 4 ID,Tid,Title,Adddate,Recommend,Verific from KS_Article Where tid='{$Param(0)}' or tid='{$Param(1)}' and verific=1 and Recommend=1 order by id desc不知道我这样写得对不对呢？

Answer 1

大家的like写错了。 有百分号。select IDfrom KS_Class where TS like'%{$Param(0)}%'

Answer 2

select top 4 ID,Tid,Title,Adddate from KS_Article Where verific=1 and Recommend=1 and Tid in(select ID from KS_Class where TS like '{$Param(0)}' ) order by id desc 没测试，你试下，里面的LIKE 你看下

Answer 3

select top 4 ID,Tid,Title,Adddate,Recommend,Verific from KS_Article Where (tid='{$Param(0)}' or tid='{$Param(1)}') and verific=1 and Recommend=1 order by id desc