ASP如何增加点击数

来源:百度知道 编辑:UC知道 时间:2024/09/25 07:15:55
<table width="433" height="36" border="0" cellpadding="0" cellspacing="0 ">
<tr>
<td width="91">ID</td>
<td width="101">标题</td>
<td width="158">时间</td>
<td width="83">点击数</td>
</tr>
<tr>
<%
for i= 1 to rs.pagesize
if rs.eof then
exit for
end if
%>

<td>
<%=rs("ID")%>
</td>
<td><a href="disp.asp?id=<%=rs("id")%>"><%=rs("title")%></a></td>
<td>
<%=rs("time")%>
</td>
<td>
<%=rs("hits")%>
</td><%
rs.movenext
next
%>
</tr>
<br>
</table>
我不知道如何让hits显示增加数 请指教

给你量身订做的,保障正确

<!--#include file "conn.asp"-->
<%set rs=server.createobject("adodb.recordset")
sql="select * from 表 where id ="&trim(request.querystring("id"))
sql1="update 表 set hits=hits+1 where id="&trim(request.querystring("id"))
conn.execute(sql1)
rs.open sql,conn,1,1
%>
<html>
<head>
<title><%=rs("title")%></title>
</head>
<body>
<table width="433" height="36" border="0" cellpadding="0" cellspacing="0 ">
<tr>
<td width="91">ID</td>
<td width="101">标题</td>
<td width="158">时间</td>
<td width="83">点击数</td>
</tr>
<tr>
<%
for i= 1 to rs.pagesize
if rs.eof then
exit for
end