
ASP翻页老是翻第二页的时候,串到别的页的数据上去
<%ifrequest("Product_ID")=""then%><divalign="center"><tablewidth="735"border="0"cellp...
<%
if request("Product_ID")="" then
%>
<div align="center">
<table width="735" border="0" cellpadding="0" cellspacing="0" background="images/bg_bg.jpg">
<%
dim classid
classid = request("classid")
%>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="80%"
border="0" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td><form action="product.asp" method="post" name="form1" id="form1">
<table width="100%" height="26" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="font8"> 产品查询:
<select name="classid" id="select5">
<option value="" selected="selected">请选择产品类别</option>
<%
sql="select * from class order by id asc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
do while not rs.eof
%>
<option value="<%=rs("id")%>"><%=rs("classname")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
直接看我博客上的连接文件: http://hi.baidu.com/%BF%EC%C0%D6%D0%A1%D5%A8%B2%CB/blog/item/8f0f1019148a684243a9add6.html 展开
if request("Product_ID")="" then
%>
<div align="center">
<table width="735" border="0" cellpadding="0" cellspacing="0" background="images/bg_bg.jpg">
<%
dim classid
classid = request("classid")
%>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="80%"
border="0" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td><form action="product.asp" method="post" name="form1" id="form1">
<table width="100%" height="26" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center" class="font8"> 产品查询:
<select name="classid" id="select5">
<option value="" selected="selected">请选择产品类别</option>
<%
sql="select * from class order by id asc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
do while not rs.eof
%>
<option value="<%=rs("id")%>"><%=rs("classname")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
直接看我博客上的连接文件: http://hi.baidu.com/%BF%EC%C0%D6%D0%A1%D5%A8%B2%CB/blog/item/8f0f1019148a684243a9add6.html 展开
1个回答
展开全部
你在翻页的时候需要把产品类别的参数带上!否则再次查询的时候就发现不是一个类别了
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询