|
主题:分享讨论在频道栏目下用SQL调用其下的频道或栏目页内容 [收藏主题] |
对于其下没有频道的调用 select top 4 id,title,hits,picturecontent,photourl,author,origin from KS_photo where tid='{$Param(0)}' and deltf=0 and verific=1 order by id desc
对于其下有频道的调用 select top 4 id,title,hits,picturecontent,photourl,author,origin from KS_photo where (tid='{$Param(0)}' or tid in(select id from ks_class where tn=(select tn from ks_class where id='{$Param(0)}'))) and deltf=0 and verific=1 order by id desc
各位有什么办法可以综合一下 |
|
支持(0) | 反对(0) 顶端 底部 |
<上一主题 | 下一主题 > |