## **query標簽 萬能數據表查詢標簽**
#
```
{query?table="link"?field="title,url"?num="12"?sqlstr="status=1"}
????<a?href='{$query.url}'?target='_blank'?>{$query.title}</a>
{/query}
```
#
## **page標簽??萬能分頁列表標簽**
#
```
<div>
??<ul>
????{page?table="book"?num="2"?sqlstr="status=1"?order="book_id?desc"}
????????<li>用戶名：{$page.username}?-?電話：{$page.mobile}</li>
????????<li>留言內容：{$page.content}</li>
????{/page}
??</ul>
<div>
<div>{$showpage}</div>
```
#
## **relate 原生sql查詢標簽**
```
{relate?sqlstr="select?a.*,b.*?from?cd_content?as?a?left?join?cd_ext_case?as?b?on?a.content_id?=?b.content_id"}
????<li>{$relate.title}?{$relate.case_des}</li>
{/relate}
```
#
