调用专题 名 链接 文章链接和文章名
如果有科汛问题不懂,或要进行二次开发的朋友可以加我Q 95018369
语句如下:select I.ID,I.Tid,I.Title,I.Adddate,I.Hits,I.Intro,I.KeyWords,I.fname,I.InfoID,I.ChannelID,
Sp.specialid,Sp.specialname,Sp.specialename,Sp.photourl,Sp.specialnote
from
KS_ItemInfo I
INNER JOIN
(select
S.specialid,S.specialname,S.specialename,S.photourl,S.specialnote,SR.InfoID
from
KS_SpecialR SR
INNER JOIN
KS_Special S ON SR.specialid = S.specialid) Sp
ON
I.InfoID = Sp.InfoID
Where
I.tid in ({$CurrClassChildID}) and I.verific=1 order by I.id desc
循环体
[loop=10]
<a href="/item/special.asp?id={$Field(specialid,Num,0,2)}">【{$Field(specialname,Text,0,...,0,)}】</a>===<a href="{$GetItemUrl}">{$Field(title,Text,0,...,0,)}</a><br>
[/loop]