求:在最新文章(24小时内发表)标题后加上一张"new"图片的代码

来源:百度知道 编辑:UC知道 时间:2024/05/09 18:39:41
原来代码为没有显示"new"图片,望各位能帮忙!!

文章发布时间字段名为"infotime"

<%

t1=0
t2=0
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="SELECT * from NEWS where jd = 'yes' and BigClassName in ('文章类别1') order by id desc"
rs.Open sql,conn,1,1
if not Rs.eof then
do while not rs.eof
t1=t1+1
if t1 mod 2=1 then
Response.Write"<tr bgcolor=#E7E7E7>"
else
Response.Write"<tr bgcolor=#F4F4F4>"
End if
%>
<td width="375" height="18">
<img src="image/webimg/pic2.gif" width="11" height="15"><a href="./info.asp?id=<%=rs("id")%>" title="<%=rs("title")%>" target="_blank"> <font color=#FF0000><%=left(rs("title"),25)%></font>
</a>&nb

<%

t1=0
t2=0
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="SELECT * from NEWS where jd = 'yes' and BigClassName in ('文章类别1') order by id desc"
rs.Open sql,conn,1,1
if not Rs.eof then
do while not rs.eof
t1=t1+1
if t1 mod 2=1 then
Response.Write"<tr bgcolor=#E7E7E7>"
else
Response.Write"<tr bgcolor=#F4F4F4>"
End if
%>
<td width="375" height="18">
<img src="image/webimg/pic2.gif" width="11" height="15"><a href="./info.asp?id=<%=rs("id")%>" title="<%=rs("title")%>" target="_blank"> <font color=#FF0000><%=left(rs("title"),25)%></font>
</a> </td>
</tr>
<%
rs.movenext
loop
end if
%>
&