<%dim rsad,sqlad,ads,ggg,dqsj
set rsad=server.createobject("adodb.recordset")
sqlad="select top 9 * from [FOX_xinxi] where yz=1 and shi="&shi&" and ts=1 and tj=1 order by fbsj desc"        
rsad.open sqlad,conn,1,1
if rsad.eof then
response.write "本地还没有...！"
else%>
<table border=0 cellspacing=0 cellpadding=0 width="388" background="images/adbg.gif">
<%do while not rsad.eof%>
<tr> 
<td class="tdtxt06" style="font-size: 12px" width="192" height="90">
<%if not rsad.eof then%>
<%dqsj=cdate(year(rsad("dqsj"))&"-"&month(rsad("dqsj"))&"-"&day(rsad("dqsj")))
ggg=dqsj-date()
%>
<%if ggg<0 then%>
<table><tr>
	<td style="font-family: 黑体; font-size: 12pt" width="190" height="20" align="center">此广告位招商<img border="0" src="images/new.gif" width="28" height="11"></td></tr>
<tr><td  height="40">黄金广告位，即时张贴，广告效果更好，更多用户注意的地方。。。</td></tr>
<tr><td><font color="#008080">不错 →</font><font color="#008000"> <a href="addzt.asp">
	<span style="text-decoration: none">抢占，我来发布>>></span></a></font></td></tr>
<tr><td>联系电话：<font color="#FF0000">0351－6618875</font></td></tr></table>
<%else%>
<table><tr>
	<td style="font-family: 黑体; font-size: 12pt" width="190" height="20" align="center"><a href="adinfo.asp?fox=<%=rsad("id")%>" target="_blank"><%if rsad("huitype")=1 then%><font color="CC3300"><%elseif rsad("huitype")=2 then%><font color="red"><%else%><%end if%><%=left(rsad("company"),8)%></font></a></td></tr>
<tr><td  height="40" align="center"><%if rsad("adpic")="0" then%><%=rsad("ad")%><%else%><a href="adinfo.asp?fox=<%=rsad("id")%>" target="_blank"><img border="0" src="adupfiles/<%=rsad("adpic")%>" width="186" height="36"></a><%end if%></td></tr>
<tr><td>属地：
<%dim rssh,sqlsheng,sqlshi,sha
set rssh=server.createobject("adodb.recordset")
sqlshi="select shi from [FOX_shi] where id="&rsad("shi")&""        
rssh.open sqlshi,conn,1,1
sha=rssh("shi")
rssh.close%><%=sha%> <%if ggg>=0 then%>&nbsp;&nbsp;
	<font color="#008080">剩</font><font color="#FF0000"><%=ggg%></font><font color="#008080">天</font><%else%><font color="#FF0000">&nbsp;&nbsp;
已过期</font><%end if%></td></tr>
<tr><td>联系：<%=left(rsad("lxrname"),4)%> [<font color="#FF0000"><%=left(rsad("usertel"),12)%></font>]</td></tr></table>
<%end if
rsad.movenext 
end if
%></td>
<td class="tdtxt06" style="font-size: 12px" width="192" height="90">
<%if not rsad.eof then%>
<%dqsj=cdate(year(rsad("dqsj"))&"-"&month(rsad("dqsj"))&"-"&day(rsad("dqsj")))
ggg=dqsj-date()
%>
<%if ggg<0 then%>
<table><tr>
	<td style="font-family: 黑体; font-size: 12pt" width="190" height="20" align="center">
	此广告位招商<img border="0" src="images/new.gif" width="28" height="11"></td></tr>
<tr><td  height="40">黄金广告位，即时张贴，广告效果更好，更多用户注意的地方。。。</td></tr>
<tr><td><font color="#008080">不错 →</font><font color="#008000"> <a href="addzt.asp">
	<span style="text-decoration: none">抢占，我来发布&gt;&gt;&gt;</span></a></font></td></tr>
<tr><td>联系电话：<font color="#FF0000">0539－6618875</font></td></tr></table>
<%else%>
<table><tr>
	<td style="font-family: 黑体; font-size: 12pt" width="190" height="20" align="center"><a href="adinfo.asp?fox=<%=rsad("id")%>" target="_blank"><%if rsad("huitype")=1 then%><font color="CC3300"><%elseif rsad("huitype")=2 then%><font color="red"><%else%><%end if%><%=left(rsad("company"),8)%></font></a></td></tr>
<tr><td  height="40" align="center"><%if rsad("adpic")="0" then%><%=rsad("ad")%><%else%><a href="adinfo.asp?fox=<%=rsad("id")%>" target="_blank"><img border="0" src="adupfiles/<%=rsad("adpic")%>" width="186" height="36"></a><%end if%></td></tr>
<tr><td>属地：
<%'dim rssh,sqlsheng,sqlshi,sha
set rssh=server.createobject("adodb.recordset")

sqlshi="select shi from [FOX_shi] where id="&rsad("shi")&""        
rssh.open sqlshi,conn,1,1
sha=rssh("shi")
rssh.close%><%=sha%> <%if ggg>=0 then%>&nbsp;&nbsp;
	<font color="#008080">剩</font><font color="#FF0000"><%=ggg%></font><font color="#008080">天</font><%else%><font color="#FF0000">&nbsp;&nbsp; 
	已过期</font><%end if%></td></tr>
<tr><td>联系：<%=left(rsad("lxrname"),4)%> [<font color="#FF0000"><%=left(rsad("usertel"),12)%></font>]</td></tr></table>
<%end if
rsad.movenext 
end if
%></td>
<td class="tdtxt06" style="font-size: 12px" width="4" height="90" bgcolor="#FFFFFF">
</td></tr>
<%ads=ads+1
if ads>=3 then exit do
loop
end if
rsad.close
set rsad=nothing
%>
</table>
<table cellSpacing="0" cellPadding="0" width="286" border="0" id="table87">
<tr>
<td>
<img height="6" src="images/_scap.gif" width="6"></td>
</tr>
</table>
