|
主题:[求助]版主请进~(附图)SQL循环调用二级栏目及当前二级栏目文章问题?? [收藏主题] |
singhh4721 发表于:2010/9/2 8:56:00 | 显示全部帖子 查看该作者主题
楼主
二级栏目的循环调用:
select id,tn,foldername,mid(classbasicinfo,instr(classbasicinfo,"||||")+4) as s,mid(s,1,instr(s,"||||")-1) as 栏目介绍 ,mid(classbasicinfo,1,instr(classbasicinfo,"||||")-1) as 栏目图片 from ks_class where tn='{$CurrClassID}' order by folderorder 栏目文章的循环调用: select ID,Title,KS_hyj,KS_msj,KS_xyj,KS_zhj from KS_Article where tid in({$CurrClassChildID}) and deltf=0 and verific=1 order by id desc 两个SQL语句要怎样结合起来??? 帮帮忙!! |
|
支持(0) | 反对(0) 顶端 底部 |
<上一主题 | 下一主题 > |