<%
set rs5=server.createobject("adodb.recordset")
sql="select * from stock where userid="&session("userid")&" order by stockid desc"//去掉where就可以行
rs5.open sql,conn,1,1
if not(rs5.eof and rs5.bof) then
do while not rs5.eof
%>
<tr>
<td align="center" bgcolor="#FFFFFF"> <%=rs5("youxi")%> </td>
<td align="center" bgcolor="#FFFFFF" > <%=rs5("fuwuqi")%> </td>
<td align="center" bgcolor="#FFFFFF" > <%=rs5("num")%> </td>
<td align="center" bgcolor="#FFFFFF"> <%=rs5("content")%> </td>
<td align="center" bgcolor="#FFFFFF" > <%=rs5("time")%> </td>
<td align="center" bgcolor="#FFFFFF" >删除 </td>
</tr>
<%
rs5.movenext
loop
else
response.write "没记录"
end if
rs5.close
set rs5=nothing
%>