刚才下载新的完整版看过了 同样少个and 补丁里ks.special.asp也是少and

感到这个SQL这样写更好些

SQLStr="Select R.ID,I.ChannelID,I.InfoID,I.Title,I.Tid,I.AddDate From KS_SpecialR R Inner Join KS_ItemInfo I On R.InfoID=I.InfoID and R.ChannelID=I.ChannelID  Where R.SpecialID=" & SpecialID & " Order by R.ID Desc"

你那语句好像少了and 了,打开admin/ks.special.asp找到508行,改成

    SQLStr="Select R.ID,I.ChannelID,I.InfoID,I.Title,I.Tid,I.AddDate From KS_ItemInfo I Inner Join KS_SpecialR R On I.InfoID=R.InfoID Where R.SpecialID=" & SpecialID & " and i.channelid=r.channelid Order by i.id Desc"