<%=getonevalue("product1","product_name","product1_id="&request("nid")&"")%>
From: Evonne Published time:<%=getonevalue("product1","createtime","product1_id="&request("nid")&"")%>
<%=getonevalue("product1","use","product1_id="&request("nid")&"")%>
Page up: <% set rs=server.CreateObject("ADODB.Recordset") sql="select top 1 * from product1 where type_id="&getonevalue("product1","type_id","product1_id="&request("nid")&"")&" and product1_id < "&request("nid")&" order by product1_id desc" rs.open sql,conn,1,1 if rs.eof then %>null <% rs.close else %> "><%=rs("product_name")%> <% rs.close end if%>
Next page: <% set rs=server.CreateObject("ADODB.Recordset") sql="select top 1 * from product1 where type_id="&getonevalue("product1","type_id","product1_id="&request("nid")&"")&" and product1_id > "&request("nid")&" order by product1_id asc" rs.open sql,conn,1,1 if rs.eof then %>null <% rs.close else %> "><%=rs("product_name")%> <% rs.close end if %>