关于判断类的SQL语句，帮我看看-领先建站CMS提供服务商我们专注于CMS建站产品的研发

1774 查看	1 回复

主题：关于判断类的SQL语句，帮我看看 [收藏主题]

wokancn 当前离线

23 主题	0 广播	0 粉丝

级别:学前班

用户积分:390 分
登录次数:17 次
注册时间:2009/4/3
最后登录:2009/7/26

wokancn 发表于：2009/5/1 8:30:00 | 只看该作者查看该作者主题楼主

一分钟快速开通线上知识店铺

我是新手，对SQL不懂，瞎写了一条，想输出文章，判断如果是图文就在左边输出图片，右边输出标题和导读，如果是普通文章就只输出标题和导读，且左边不留空。写了一下，却不显示，大家看看问题在哪

[loop=1]

{$IF({$Field(Picurl,Num,0,2)}=1||<DIV class="news_item news_item_first"><P class=news_img><A title={$Field(Title,Text,0,...,0,)}
href="{$Field(ID,GetInfoUrl,1,1)}" target=_blank><IMG
height=75 alt={$Field(Title,Text,0,...,0,)}
src="{$Field(Picurl,Text,0,...,0,)}"
width=100></A></P>
<DIV class=news_content_img><DIV class=title>
<UL>
<LI><IMG src="images/1/ding.gif"> </LI>
<LI class=number>{$Field(Hits,Num,0,2)}</LI>
<LI><A title={$Field(Title,Text,0,...,0,)}
href="{$Field(ID,GetInfoUrl,1,1)}"
target=_blank>{$Field(Title,Text,{$Param(1)},.,0,)}</A>{$IF({$Field(recommend,Num,0,2)}=1||推荐<IMG src="images/1/arrow_up.gif" name=up>||)} </LI></UL>
<P>【{$Field(Adddate,Text,0,...,0,)}】</P>
<DIV class=clearer></DIV></DIV>
<P
class=description>>{$Field(Intro,Text,160,...,0,)}</P>
<P class=link><A title={$Field(Title,Text,0,...,0,)}
href="{$Field(ID,GetInfoUrl,1,1)}"
target=_blank>{$Field(ID,GetInfoUrl,1,1)}</A></P>
<UL class=tag>
<LI><A>{$Field(KeyWords,Text,0,...,0,)}</A>
<LI><A class=jq_a_show title=相关文章
href="http://app.chinavisual.com/b/index_news/page/index.html#relative_104603"><IMG
style="DISPLAY: none" src="images/1/arrow_down.gif"
name=down><IMG src="images/1/arrow_up.gif" name=up></A>
</LI></UL></DIV>
<DIV class=clearer></DIV></DIV>||<DIV class="news_item news_item_first">
<DIV class=news_content>
<DIV class=title>
<UL>
<LI><IMG src="images/1/ding.gif"> </LI>
<LI class=number>{$Field(Hits,Num,0,2)}</LI>
<LI><A title={$Field(Title,Text,0,...,0,)}
href="{$Field(ID,GetInfoUrl,1,1)}"
target=_blank>{$Field(Title,Text,{$Param(1)},.,0,)}</A>{$IF({$Field(recommend,Num,0,2)}=1||推荐<IMG src="images/1/arrow_up.gif" name=up>||)} </LI></UL>
<P>【{$Field(Adddate,Text,0,...,0,)}】</P>
<DIV class=clearer></DIV></DIV>
<P
class=description>>{$Field(Intro,Text,160,...,0,)}</P>
<P class=link><A title={$Field(Title,Text,0,...,0,)}
href="{$Field(ID,GetInfoUrl,1,1)}"
target=_blank>{$Field(ID,GetInfoUrl,1,1)}</A></P>
<UL class=tag>
<LI><A>{$Field(KeyWords,Text,0,...,0,)}</A>
<LI><A class=jq_a_show title=相关文章
href="http://app.chinavisual.com/b/index_news/page/index.html#relative_104603"><IMG
style="DISPLAY: none" src="images/1/arrow_down.gif"
name=down><IMG src="images/1/arrow_up.gif" name=up></A>
</LI></UL></DIV>
<DIV class=clearer></DIV></DIV>)}