%dim pid,i
pid=request.QueryString("pid")%>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select ename from paintings where pid="&pid&" ",conn,1,1
%>
<%=trim(rs("ename"))%>--ZHAO'S OIL PAINTINGS GALLERY|Tibet oil paintings|Tibet arts|Tibet pictures|Tibet photo|Oil paintings about Tibet|Tibet <%=trim(rs("ename"))%> oil paintings|Tibet arts <%=trim(rs("ename"))%>|Tibet pictures <%=trim(rs("ename"))%>|Tibet photo <%=trim(rs("ename"))%>|Oil paintings about Tibet <%=trim(rs("ename"))%>
<%dim rs3,totalnum
set rs3=server.CreateObject("adodb.recordset")
rs3.open "select * from paintings order by pid",conn,1,1
totalnum=rs3.recordcount
if pid=1 then
%>
INDEX >NEXT
<% else
if pid=totalnum then
%>
>PREVIOUS INDEX
<% else %>
>PREVIOUS INDEX >NEXT
<% end if %>
<% end if
rs3.close
set rs3=nothing
%>