查询语句

select AddDate,KS_zt,KS_ch,KS_email,KS_lxfs,KS_KS_fbnl,Note from KS_Form_lyxx

请教了``

如何显示图片

查询语句

select AddDate,KS_xm,KS_xb,KS_csnf,KS_csyf,KS_jg,KS_mz,KS_jdnj,KS_byxx,KS_hksz,KS_jtzz,KS_lxdh,KS_yddh,KS_xp,KS_zwjs,KS_hjqk,KS_dccy,Note from KS_Form_zsbm

循环体：

[loop=2]

<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#000033" style='border:1px #BAAB10 solid'>

<tr class="tdbg">

  <td width="13%" height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>姓名：</td>

  <td width="28%" style='border: 1px solid #6699cc'>{$Field(KS_xm,Text,0,...,0,)}</td>

  <td width="11%" align="right" style='border: 1px solid #6699cc'><span class="lefttdbg">性别：</span></td>

  <td width="19%" style='border: 1px solid #6699cc'>{$Field(KS_xb,Text,0,...,0,)}</td>

  <td width="29%" align="center" style='border: 1px solid #6699cc'>发表时间：{$Field(AddDate,Text,0,...,0,)}</td>

</tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>出生年份：</td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_csnf,Text,0,...,0,)}年{$Field(KS_csyf,Text,0,...,0,)}月</td>

  <td align="right" style='border: 1px solid #6699cc'><span class="lefttdbg">籍贯：</span></td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_jg,Text,0,...,0,)}</td>

  <td width="29%" rowspan="5" align="center" style='border: 1px solid #6699cc'>{$Field(KS_xp,Text,0,...,0,)}</td>

</tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>民族：</td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_mz,Text,0,...,0,)}</td>

  <td align="right" style='border: 1px solid #6699cc'><span class="lefttdbg">就读年级：</span></td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_jdnj,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>毕业学校：</td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_byxx,Text,0,...,0,)}</td>

  <td align="right" style='border: 1px solid #6699cc'><span class="lefttdbg">户口所在：</span></td>

  <td style='border: 1px solid #6699cc'>{$Field(KS_hksz,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>家庭住址：</td>

  <td colspan="3" style='border: 1px solid #6699cc'>{$Field(KS_jtzz,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>联系电话：</td>

  <td colspan="3" style='border: 1px solid #6699cc'>{$Field(KS_lxdh,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td height="20" align="right" class="lefttdbg" style='border: 1px solid #6699cc'>移动电话：</td>

  <td colspan="4" style='border: 1px solid #6699cc'>{$Field(KS_yddh,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg" style='border: 1px solid #6699cc'>

  <td height="15" colspan="5" align="center" valign="middle" class="lefttdbg" style='border: 1px solid #6699cc'>&nbsp;</td>

  </tr>



<tr class="tdbg">

  <td align="right" class="lefttdbg" style='border: 1px solid #6699cc'>自我介绍：</td>

  <td height="100" colspan="4" valign="top" style='border : 1px solid #6699cc'>{$Field(KS_zwjs,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td align="right" class="lefttdbg" style='border: 1px solid #6699cc'>获奖情况：</td>

  <td height="100" colspan="4" valign="top" style='border: 1px solid #6699cc'>{$Field(KS_hjqk,Text,0,...,0,)}</td>

  </tr>

<tr class="tdbg">

  <td align="right" class="lefttdbg" style='border: 1px solid #6699cc'>特长才艺：</td>

  <td height="100" colspan="4" valign="top" style='border: 1px solid #6699cc'>{$Field(KS_dccy,Text,0,...,0,)}</td>

  </tr>

</table>

<table width="100%" border="0">

  <tr>

    <td height="25">&nbsp;</td>

  </tr>

</table>

[/loop]

效果图：

像文章一下` 按表单填写时间来排序`(降序)