select ID,定义的字段 from KS_数据表 where Tid='栏目号' order by adddate desc(按添加时间降序排列)

本例的查询语句完整的表达为:

select ID,KS_s04cj,KS_s04mt,KS_s04nh,KS_s04wj,KS_s07cj,KS_s07mt,KS_s07nh,KS_s07wj,KS_s98cj,KS_s98mt,KS_s98nh,KS_s98wj,KS_scj,KS_sdate,KS_smt,KS_snh,KS_swj from KS_U_swgg where Tid='20083569246192' order by adddate desc

4.点下一步,在循环体中拷入在DW软件中制作的表样代码,在[loop=1][/loop]循环体中分别插入需要表达的自定义字段内容,根据需要修改[loop=1]中值,我这里只需显示一天的,值就是1.

<table width=100% border="1" cellspacing="0" cellpadding="0">
  <tr align="center">
    <td colspan="5"><strong><font size="3pt">二00八年度九江县汛期水位公告</font></strong></br />(4月-9月)单位:米</td>
  </tr>
  <tr>
    <td width=20% rowspan="2" align="center">日期</td>
    <td width=20% rowspan="2" align="center">长江水位</td>
    <td colspan="2" align="center">赛城湖大闸</td>
    <td width=20% rowspan="2" align="center">马头水库</td>
  </tr>
  <tr>
    <td width=20% align="center">内湖</td>
    <td width=20% align="center">外江</td>
  </tr>
[loop=1]
  <tr>
    <td>{$Field(KS_sdate,Text,0,0,0,)}</td>
    <td>{$Field(KS_scj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_snh,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_swj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_smt,Text,0,0,0,缺报)}</td>
  </tr>
  <tr>
    <td>昨日水位</td>
    <td>{$Field(KS_s04cj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s04nh,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s04wj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s04mt,Text,0,0,0,缺报)}</td>
  </tr>
  <tr>
    <td>去年同期</td>
    <td>{$Field(KS_s07cj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s07nh,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s07wj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s07mt,Text,0,0,0,缺报)}</td>
  </tr>
  <tr>
    <td>98年同期</td>
    <td>{$Field(KS_s98cj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s98nh,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s98wj,Text,0,0,0,缺报)}</td>
    <td>{$Field(KS_s98mt,Text,0,0,0,缺报)}</td>
  </tr>
[/loop]
</table>

5.在首页模板需要显示的地方插入标签:{SQL_今日水位()}

6.在后台今日水位栏目中添加文章时在出现的自定义的字段中分别填入内容.