Question

asp 数据库 select语句怎么写？

数据库

要实现下面效果，怎么写select语句

user 2012-2-13 2012-2-14
1 6：52 7:32
2 7:04 7:05

网页上显示上面的效果怎么写代码，请高手指教

Answer 1

<style type="text/css">
ul{float:left; width:100px; margin:0; padding:0px; border:1px solid #CCC;}
li{width:100px; height:20px; padding-top:10px; border-bottom:1px solid #CCC; border-right:1px solid #CCC;}
</style>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select format(f_time,'yyyy-MM-DD') as t from checktime group by format(f_time,'yyyy-MM-DD')",conn,1,1
if not rs.eof then
do while not rs.eof
response.Write "<ul>"
response.Write "<li>"&rs(0)&"</li>"
set rss=server.CreateObject("adodb.recordset")
rss.open "select * from checktime where format(f_time,'yyyy-MM-DD')='"&rs(0)&"'",conn,1,1
if not rss.eof then
do while not rss.eof
response.Write "<li>"&Hour(rss(1))&":"&Minute(rss(1))&"</li>"

rss.movenext
loop
end if
rss.close
set rss=nothing
response.Write "</ul>"
rs.movenext
loop
end if
rs.close
set rs=nothing
%>

Answer 2

楼上的回答对着呢。。。。