%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "prodraw"
id2=Request("id")
list = "SELECT hits From demoroom WHERE id="+id2+""
Set RS = Conn.Execute( list )
'## update page hits
hits2 = rs("hits") + 1
sql = "UPDATE demoroom SET hits='" & hits2 & "' WHERE id="+id2+""
Set rs = conn.Execute(sql)
Back_command = "SELECT id From demoroom WHERE id<"+id2+" order by id desc"
Set BackRs= Conn.Execute(Back_command)
Next_command = "SELECT id From demoroom WHERE id>"+id2+" order by id"
Set NextRs= Conn.Execute(Next_command)
if not(BackRS.eof) then
Back_String=""
else
Back_String="
"
end if
if not(NextRS.eof) then
Next_String = "
"
else
Next_String = "
"
end if
list = "SELECT * From demoroom WHERE id="+id2+""
Set RS = Conn.Execute( list )
imagetitle2=RS("imagetitle")
name2=RS("name")
site2=RS("site")
copyright2=RS("copyright")
comments2 = Replace ((RS("comments")),chr(13),"
")
imagetitle3= Replace(imagetitle2,"''","'")
name3= Replace(name2,"''","'")
site3= Replace(site2,"''","'")
copyright3= Replace(copyright2,"''","'")
comments3= Replace(comments2,"''","'")
%>
![]() ![]() ![]() ![]() |
|
![]() |
|
![]() |
||
![]() |
<%=Next_String%>
|
|
![]() |
|