标签名称：最新企业

sql语句：select top 10 a.CompanyName,b.userid,b.logo from KS_Enterprise a inner join KS_blog b on a.username=b.username where a.status=1 order by a.id desc

循环体

[loop=50]

<li><a href="/space/?{$Field(userid,Num,0,2)}" target="_blank">

<img src="{$Field(logo,Text,0,...,0,/images/nopic.gif)}" width="130" height="120" /><br/>

{$Field(CompanyName,Text,0,...,0,)}</a> </li>

[/loop]

调用:{SQL_最新企业()}

说明如下只想调用有上传logo的企业，可以将sql语句改成

select top 10 a.CompanyName,b.userid,b.logo from KS_Enterprise a inner join KS_blog b on a.username=b.username where b.logo<>'' and a.status=1 order by a.id desc

如果只想调用推荐的企业，可以改成

select top 10 a.CompanyName,b.userid,b.logo from KS_Enterprise a inner join KS_blog b on a.username=b.username where b.recommend=1 and  a.status=1 order by a.id desc

收藏一下啊！