TAB形式的用SQL标签实现文章系统图片分页-领先建站CMS提供服务商我们专注于CMS建站产品的研发

1512 查看	1 回复

主题：TAB形式的用SQL标签实现文章系统图片分页 [收藏主题]

chy50953389 当前离线

67 主题	0 广播	0 粉丝

级别:学前班

用户积分:935 分
登录次数:122 次
注册时间:2008/5/27
最后登录:2017/4/28

chy50953389 发表于：2009/5/21 14:40:00 | 只看该作者查看该作者主题楼主

做考试题库就用#科汛在线考试系统!

查询语句
select ID,Tid,Title,Picurl from KS_Article where deltf=0 and verific=1 and picnews=1 order by id desc

循环体写法

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>[loop=3]
    <td style="border-bottom:1px #CCCCCC dashed;"><A title="{$Field(Title,Text,0,,0,)}" href="{$Field(ID,GetInfoUrl,1,1)}" target=_blank><img alt="{$Field(Title,Text,0,,0,)}" src="{$Field(Picurl,Text,0,,0,)}" width="150" height="110" border="0"/>
      <br>
      <a href="/?list-535.html" target=_blank><img src="/images/yd.jpg" width="65" height="21" border="0"></a><br>
{$Field(Title,Text,20,,0,)}
</td>[/loop]
<tr>[loop=3]
    <td style="border-bottom:1px #CCCCCC dashed;"><A title="{$Field(Title,Text,0,,0,)}" href="{$Field(ID,GetInfoUrl,1,1)}" target=_blank><img alt="{$Field(Title,Text,0,,0,)}" src="{$Field(Picurl,Text,0,,0,)}" width="150" height="110" border="0"/>
      <br><a href="/?list-535.html" target=_blank><img src="/images/yd.jpg" width="65" height="21" border="0" /></a><br>
{$Field(Title,Text,20,,0,)}
</td>[/loop]
<tr>[loop=3]
    <td style="border-bottom:1px #CCCCCC dashed;"><A title="{$Field(Title,Text,0,,0,)}" href="{$Field(ID,GetInfoUrl,1,1)}" target=_blank><img alt="{$Field(Title,Text,0,,0,)}" src="{$Field(Picurl,Text,0,,0,)}" width="150" height="110" border="0"/>
      <br>
      <a href="/?list-535.html" target=_blank><img src="/images/yd.jpg" width="65" height="21" border="0" /></a><br>
{$Field(Title,Text,20,,0,)}
</td>[/loop]
</tr>
</table>