[DedeCMS]SQL标记帮助文档索引
推荐企业:
=======================================================
{dede:sql sql="SELECT m.ID,m.type,m.userid,m.matt,c.id,c.comname
FROM #@__member m
left join #@__member_cominfo c on m.ID = c.id
where m.type = 1 and m.matt = 1
LIMIT 0 , 10"}
<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
{/dede:sql}
========================================================
最新企业调用
========================================================
{dede:sql sql="SELECT m.ID, m.type, m.userid,c.id, c.comname
FROM #@__member m
LEFT JOIN #@__member_cominfo c ON m.ID = c.id
WHERE m.type =1
ORDER BY `m`.`ID` DESC
LIMIT 0 , 10 "}
<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:comname/]</a>
{/dede:sql}
=======================================================
要限制字段的长度可以使用DEDE内置的函数 cn_substr
使用方法为
[field:comname function='cn_substr(@me,20)'/]
DEDE首页调用DZ论坛图片的方法
=====================================================
{dede:sql sql="SELECT`cdb_attachments`.`aid`, `cdb_attachments`.`attachment`,`cdb_threads`.`tid`, `cdb_threads`.`fid`, `cdb_threads`.`subject` FROM `cdb_attachments` LEFT JOIN `cdb_threads` ON `cdb_threads`.`tid`=`cdb_attachments`.`tid` WHERE `cdb_attachments`.`readperm`='0' AND `displayorder`>='0' AND `filetype`='image/pjpeg' GROUP BY tid LIMIT 0,1 "}
<a href="/bbs/viewthread.php?tid=[field:tid /]">
<img src="/bbs/attachments/[field:attachment/]"
</A>
{/dede:sql}
======================================================
推荐会员
==================================================
{dede:sql sql="SELECT ID,type,userid,uname,matt,spaceimage
FROM #@__member
where matt = 1 and type=0
LIMIT 0 , 10"}
头像：<img src="[field:spaceimage runphp='yes']
if(!@me)@me = 'upload/2009/11/200911251621501623.gif';
[/field:spaceimage]" />
用户名：<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/'>[field:uname/]</a>
{/dede:sql}
==================================================
[field:spaceimage runphp='yes']
if(!@me)@me = 'upload/2009/11/200911251621501623.gif';
[/field:spaceimage]
为用户头像图片
