sql语句：

如

select top 10 BigPhoto,ID,PackName from KS_ShopPackage where status=1 and packtype=0 order by id

循环体

[loop=10]

<li><a href="/shop/pack.asp?id={$Field(ID,GetInfoUrl,0,2)}">{$Field(PackName,Text,0,...,0,)}</a></li>

[/loop]

其中packtype=0是自选礼包，1是特惠礼包