先看一下效果：
此主题相关图片如下：snap2.jpg
页面代码：
<html>
<head>
<style type="text/css">
<!--
A
{
TEXT-DECORATION: none;
}
A:hover
{
COLOR: #0099FF;
}
A:link {
color: #205064;
}
A:visited {
color: #006699;
}
BODY
{
FONT-FAMILY: "宋体";
FONT-SIZE: 12pt;
text-decoration: none;
line-height: 150%;
background-color: #F5F5F0;
}
TD
{
FONT-FAMILY:宋体;
FONT-SIZE: 9pt;
}
Input
{
FONT-SIZE: 9pt;
HEIGHT: 20px;
}
Button
{
FONT-SIZE: 9pt;
HEIGHT: 20px;
}
Select
{
FONT-SIZE: 9pt;
HEIGHT: 20px;
}
.border
{
border: 1px solid #B3CBFF;
}
.border2
{
background:#FFFFFF;
border: 1px solid #F1F1F1;
}
.title
{
background:#f6f6f6;
line-height: 30pc;
}
.title_left
{
background:url(images/left_bg.gif);
}
.title_right
{
background:url(images/right_bg.gif);
}
.title_main
{
background:url(Images/jiaodian_bg.gif);
line-height: normal;
}
.tdbg{
background:#FFFFFF;
line-height: 120%;
}
.tdbg_left{
background:#fef8ed;
line-height: 150%;
}
.tdbg_right{
background:#EAF1FB;
line-height: 150%;
}
.tdbg_main{
background:#ffffff;
line-height: 150%;
}
.topborder
{
border-right: 1px solid #6687BA;
border-left: 1px solid #6687BA;
border-bottom: 1px solid #6595D6;
width: 760px;
}
.nav_top
{
background-image: url(Skin/1/topbg.gif);
}
.nav_bottom
{
background-image: url(Skin/1/bottombg.gif);
}
.nav_menu
{
background:url(Skin/1/topBar_bg.gif);
}
.menu
{
background-color: #F0F9FF;
width:97%;
border: 1px;
}
td.MenuBody
{
background-color: #F0F9FF;
}
.m {
font-size: 12px;
line-height: 20px;
font-weight: normal;
}
.picb {
border: 1px solid #000066;
}
-->
</style>
</head>
<body >
<table class=m height=18 cellSpacing=0 cellPadding=0 width=280 align=left border=0>
<tr>
<td height=18>{SQL_测试效果()}</td>
</tr>
</table>
</body>
</html>
SQL语句：
select top 10 ID,Tid,Title,Author,Origin,Adddate,Hits,FullTitle from KS_Article order by ID desc
标签内容：
[loop=10]
<table border=0 width='100%' cellspacing=0 cellpadding=1><tr><td ><img src='../images/point.gif' alt='最新文章'><a href='{$Field(ID,GetInfoUrl,1,1)}' title='文章标题：{$Field(FullTitle,Text,0,...,0,"")}
作 者：{$Field(Author,Text,0,...,0,"")}
更新时间：{$Field(Adddate,Date,YYYY-MM-DD)}
点击次数：150' target='_blank'><font color=''>{$Field(Title,Text,20,...,0,)}</font> [{$Field(Tid,GetClassUrl,1,0)}] <font color=red>[{$Field(Hits,Num,0,2)}]</font></td><td valign='bottom' nowrap align='right' style='width:1%; padding-right:5px'><font color=#999999>{$Field(Adddate,Date,MM-DD)}</font></td></tr><tr><td colspan='2'><table width='99%' border=0 cellspacing=0 cellpadding=0><tr><td height=1 ></td></tr></table></td></tr></table>
[/loop]
当前位置：
支持(0) | 
反对(0)
顶端 
底部
![电子邮件:[ wei_ping1979@163.com ]](http://bbs.kesion.com/club/images/email.gif){kind=small}
![QQ号码:[ 67663233 ]](http://bbs.kesion.com/club/images/qq.gif){kind=small}
