孤独的狐狸

本博客资源全部来自互联网,只作为个人记事本之用,不承担版权责任问题。

2009-08-12 00:01

最新企业和推荐企业的SQL码

推荐企业
{dede:sql sql="SELECT m.mtype,c.company,m.userid FROM dede_member as m left join dede_member_company c on m.mid = c.mid where m.matt='1' and m.mtype ='企业'"}
<li><span><a href='/member/index.php?uid=[field:userid/]' target="_blank">[field:company/]</a></span> 用户:[field:userid/]</li>
{/dede:sql}

最新企业
{dede:sql sql="SELECT m.mtype,c.company,m.userid FROM dede_member as m left join dede_member_company c on m.mid = c.mid where m.mtype ='企业'"}
<li><span><a href='/member/index.php?uid=[field:userid/]' target="_blank">[field:company/]</a></span> 用户:[field:userid/]</li>
{/dede:sql}
评论