%
set rs=server.createobject("adodb.recordset")
id=cstr(request("id"))
conn.execute ("update news set hits=hits+1 where newsid="&id )
sqltext="select *from news where newsid="& id
rs.open sqltext,conn,adopenkeyset,adlockoptimistic,adcmdtext
set rs1=server.createobject("adodb.recordset")
sqltext="select *from news where typeid="&cstr(request("type"))
rs1.open sqltext,conn,adopenkeyset,adlockoptimistic,adcmdtext
%>