注册
找回密码
账号 记住
3026
12
1204
0
楼主的意思是当前文章所在栏目下的其它文章吗?是的话用下边的SQL语句应该可以实现
select a.Adddate,a.Hits ,a.ID,a.Tid, a.Title, a.Picurl,b.id,b.tid from KS_Article as a, KS_Article as b where a.tid=b.tid and b.id={$CurrInfoID} and a.id<>{$CurrInfoID} order by a.Adddate desc