Question

asp如何查询数据库今天新添加的数据 当然都有时间记录

如何写代码

Answer 1

数据记录的时间=当前时间
<%
set rs = server.CreateObject("adodb.recordset")
rs.open "select * from 表 where Time like '%"&Now()&"%' order by ID desc",conn,1,1
if rs.eof and rs.bof then
response.Write "今天没有新发布"
else
do while not rs.eof
response.write "内容"
rs.movenext
loop
rs.close
set rs = nothing
end if %>