昨天久问没人回答，所以自己查询论坛发现有这样一个解决方法，不过循环不能超过5个。大约是目录品牌不够的缘故

[replyview]

查询语句：

select top 5 c.classid,a.id,a.brandname,PhotoUrl from (ks_classbrand a inner join ks_classbrandr b on a.id=b.brandid) inner join ks_class c on b.classid=c.id where b.classid in({$CurrClassChildID}) order by folderorder

循环语句：[loop=5]{$IF(Fcls.RefreshFolderID={$Field(ID,GetInfoUrl,100,2)}||<li class="undis"><a href="/shop/Search_list.asp?id=1&brandid={$Field(id,GetInfoUrl,100,2)}" target="_blank"><img src="{$Field(PhotoUrl,Text,0,...,0,)}" width="120" height="90" style="border:#CCC 1px solid;"><br />{$Field(brandname,Text,0,...,0,)}</a></li>||<li><a href="/shop/Search_list.asp?id=1&brandid={$Field(id,GetInfoUrl,100,2)}" target="_blank"><img src="{$Field(PhotoUrl,Text,0,...,0,)}" width="120" height="90" style="border:#CCC 1px solid;"><br />{$Field(brandname,Text,0,...,0,)}</a></li>)}[/loop]

[/replyview]

高手帮忙啊