账号通
    

注册

找回密码

账号  

密码  

话题
互动
会员
服务
<<返回列表上一个主题 下一个主题 打印本帖 复制本帖地址

6877

查看

1

回复
主题：[求助]SQL如何降序排列？（已解决） [收藏主题]  
baotou 当前离线

144

主题

0

广播

0

粉丝
添加关注
级别:一年级

用户积分:843 分
登录次数:82 次
注册时间:2007/12/23
最后登录:2014/4/15
baotou 发表于：2010/1/27 11:46:00   | 只看该作者 查看该作者主题 楼主 
做线上考试培训 就选#科汛网校

[loop=1 ]
<li class="huali1 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" ><img src=" {$Field(PhotoUrl,Text,0,...,0,)} "   alt="{$Field(Title,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11"><span>价格:<b>{$Field(KS_zpjg,Num,0,2)}</b></span>
            <a  class="zuozhe"  >{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2" > {$Field(KS_cc,Text,0,...,0,)} </span>
            <span class="span12"> [{$Field(KS_zplb,Text,0,...,0,)}] </span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]
[loop=1 ]
<li class="huali2 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" title="{$Field(Title,Text,0,...,0,)}"><img src=" {$Field(PhotoUrl,Text,0,...,0,)}"   alt="{$Field(Author,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11" > <span> 价格:<b> {$Field(KS_zpjg,Num,0,2)}</b></span>
            <a href="/huajia/158.shtml" target="_blank" class="zuozhe"  title="{$Field(Author,Text,0,...,0,)}">{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2">{$Field(KS_cc,Text,0,...,0,)}</span>
            <span class="span12">[{$Field(KS_zplb,Text,0,...,0,)}]</span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href="{$Field(ID,GetInfoUrl,116,1)}" target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]


[loop=1 ]
<li class="huali1 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" ><img src=" {$Field(PhotoUrl,Text,0,...,0,)} "   alt="{$Field(Title,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11"><span>价格:<b>{$Field(KS_zpjg,Num,0,2)}</b></span>
            <a  class="zuozhe"  >{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2" > {$Field(KS_cc,Text,0,...,0,)} </span>
            <span class="span12"> [{$Field(KS_zplb,Text,0,...,0,)}] </span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop ]
[loop=1]
<li class="huali2 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" title="{$Field(Title,Text,0,...,0,)}"><img src=" {$Field(PhotoUrl,Text,0,...,0,)}"   alt="{$Field(Author,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11" > <span> 价格:<b> {$Field(KS_zpjg,Num,0,2)}</b></span>
            <a href="/huajia/158.shtml" target="_blank" class="zuozhe"  title="{$Field(Author,Text,0,...,0,)}">{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2">{$Field(KS_cc,Text,0,...,0,)}</span>
            <span class="span12">[{$Field(KS_zplb,Text,0,...,0,)}]</span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href="{$Field(ID,GetInfoUrl,116,1)}" target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]


[loop=1 ]
<li class="huali1 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" ><img src=" {$Field(PhotoUrl,Text,0,...,0,)} "   alt="{$Field(Title,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11"><span>价格:<b>{$Field(KS_zpjg,Num,0,2)}</b></span>
            <a  class="zuozhe"  >{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2" > {$Field(KS_cc,Text,0,...,0,)} </span>
            <span class="span12"> [{$Field(KS_zplb,Text,0,...,0,)}] </span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]
[loop=1 ]
<li class="huali2 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" title="{$Field(Title,Text,0,...,0,)}"><img src=" {$Field(PhotoUrl,Text,0,...,0,)}"   alt="{$Field(Author,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11" > <span> 价格:<b> {$Field(KS_zpjg,Num,0,2)}</b></span>
            <a href="/huajia/158.shtml" target="_blank" class="zuozhe"  title="{$Field(Author,Text,0,...,0,)}">{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2">{$Field(KS_cc,Text,0,...,0,)}</span>
            <span class="span12">[{$Field(KS_zplb,Text,0,...,0,)}]</span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href="{$Field(ID,GetInfoUrl,116,1)}" target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]


[loop=1 ]
<li class="huali1 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" ><img src=" {$Field(PhotoUrl,Text,0,...,0,)} "   alt="{$Field(Title,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11"><span>价格:<b>{$Field(KS_zpjg,Num,0,2)}</b></span>
            <a  class="zuozhe"  >{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2" > {$Field(KS_cc,Text,0,...,0,)} </span>
            <span class="span12"> [{$Field(KS_zplb,Text,0,...,0,)}] </span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]
[loop=1 ]
<li class="huali2 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" title="{$Field(Title,Text,0,...,0,)}"><img src=" {$Field(PhotoUrl,Text,0,...,0,)}"   alt="{$Field(Author,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11" > <span> 价格:<b> {$Field(KS_zpjg,Num,0,2)}</b></span>
            <a href="/huajia/158.shtml" target="_blank" class="zuozhe"  title="{$Field(Author,Text,0,...,0,)}">{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2">{$Field(KS_cc,Text,0,...,0,)}</span>
            <span class="span12">[{$Field(KS_zplb,Text,0,...,0,)}]</span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href="{$Field(ID,GetInfoUrl,116,1)}" target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]


[loop=1 ]
<li class="huali1 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" ><img src=" {$Field(PhotoUrl,Text,0,...,0,)} "   alt="{$Field(Title,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11"><span>价格:<b>{$Field(KS_zpjg,Num,0,2)}</b></span>
            <a  class="zuozhe"  >{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2" > {$Field(KS_cc,Text,0,...,0,)} </span>
            <span class="span12"> [{$Field(KS_zplb,Text,0,...,0,)}] </span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]
[loop=1 ]
<li class="huali2 clearfix">
 <a href=" {$Field(ID,GetInfoUrl,116,1)} " target="_blank" title="{$Field(Title,Text,0,...,0,)}"><img src=" {$Field(PhotoUrl,Text,0,...,0,)}"   alt="{$Field(Author,Text,0,...,0,)}"/></a>
          <div class="imgdiv2"> <span class="span10">{$Field(Title,Text,0,...,0,)}</span><br />
            <span class="span11" > <span> 价格:<b> {$Field(KS_zpjg,Num,0,2)}</b></span>
            <a href="/huajia/158.shtml" target="_blank" class="zuozhe"  title="{$Field(Author,Text,0,...,0,)}">{$Field(Author,Text,0,...,0,)}</a>
            <span class="zuozhe2">{$Field(KS_cc,Text,0,...,0,)}</span>
            <span class="span12">[{$Field(KS_zplb,Text,0,...,0,)}]</span>
            <span id="xs2">[<s>{$Field(KS_sszt,Text,0,...,0,)}</s>]</span>
            <a href="{$Field(ID,GetInfoUrl,116,1)}" target="_blank" class="xiangqing"  title="{$Field(Title,Text,0,...,0,)}">作品详情</a>          
            </span>
          </div>
</li>
[/loop]


 


 


如上语句


 


是在查询语句后加


order by id desc
哈哈

 
 
科汛商学院助您快速入门
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
baotou 当前离线

144

主题

0

广播

0

粉丝
添加关注
级别:一年级

用户积分:843 分
登录次数:82 次
注册时间:2007/12/23
最后登录:2014/4/15
baotou 发表于：2010/1/27 14:04:00   | 只看该作者 查看该作者主题 沙发 
科汛在线网校系统
有生源 找课程 就上科汛课堂街!
但是我两行的效果是不一样的啊，
 
做官网 就用科汛智能建站系统!
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
ks1w 当前离线

2796

主题

4

广播

1

粉丝
添加关注
级别:大一

用户积分:14338 分
登录次数:665 次
注册时间:2006/11/3
最后登录:2019/7/26
ks1w 发表于：2010/1/27 13:36:00   | 只看该作者 查看该作者主题 藤椅 
科汛智能建站系统
做官网 就用科汛智能建站系统!

你放那么多loop干嘛

 

 

用{$AutoID}就可以循环行号了
 
做新职业技能培训平台 就选#科汛网校
  支持(0) | 反对(1) 回到顶部顶端 回到底部底部
＜上一主题 | 下一主题 ＞
<< 返回列表
Powered By KesionCMS Version X1
厦门科汛软件有限公司 © 2006-2016 页面执行0.28223秒 powered by KesionCMS 9.0