POST TIME:2020-03-28 16:58
織夢(mèng)CMS中企業(yè)推薦會(huì)員如何調(diào)用?其實(shí)推薦的只要加多一個(gè) matt='1' ,其代碼如下:
{dede:sql sql="SELECT comname,userid FROM dede_member_cominfo AS c LEFT JOIN dede_member AS m ON c.id=m.ID WHERE m.type='1' and matt='1' ORDER BY m.jointime DESC LIMIT 0,12"}
<a href='[field:global name='cfg_cmspath'/]/member/?[field:userid/]/' target=_blank>[field:comname/]</a><br>
{/dede:sql}
紅色為增加條件