语句

select top 6 * from KS_Product where IsSpecial=1 order by id desc

循环

<style type="text/css">

<!--

.scj {color: #999999}

.hyj {

color: #CC0000;

font-weight: bold;

}

-->

</style>

<ul>

[loop=6]

<li style="width:33%;float:left;list-style:none; text-align:center;">

<table width="200" border="0" cellpadding="0" cellspacing="0" style="border-left:#eeeeee 1px dashed; margin:-top:5px;">

  <tr>

    <td colspan="2" align="center"><a href="{$Field(ProID,GetInfoUrl,5,1)}" target="_blank"><img src="{$Field(PhotoUrl,Text,0,...,0,)}" alt="" width="140" height="177" border="0"></a></td>

  </tr>

  <tr>

    <td colspan="2" align="center"><a href="{$Field(ProID,GetInfoUrl,5,1)}" target="_blank">{$Field(Title,Text,0,...,0,)}</a></td>

  </tr>

  <tr>

    <td width="50%" align="right"><span class="scj"><del>￥{$Field(Price_Market,Num,0,2)}</del></span></td>

    <td width="50%"><span class="hyj">￥{$Field(Price_Member,Num,0,2)}</span></td>

  </tr>

</table>

<li>

[/loop]

</ul>