56770_showsort.asp

能进行网上购物的需求

<%
dim page, sort_name
dim maxPerPage '每页显示的产品数
dim num_row '每行显示的产品个数
dim rows '显示的产品行数
num_row=1 '每行放置的产品数
rows=5 '放置的产品行数
maxperpage=num_row*rows
myKeyword=Request("myKeyword")
page=Request("page")
session("oldUrl")="./"
if(page="" or isempty(page))then page=1
if request("csort_id")="" then
  thisUrl="showsort.asp?sort_id="&request("sort_id")
else
  thisUrl="showcsort.asp?sort_id="&request("sort_id")&"&csort_id="&request("csort_id")
end if
session("oldUrl")=thisUrl&"&page="&page
Set rs=Server.CreateObject("ADODB.RecordSet")
if request("csort_id")="" then
  sql="select * from 56770_product where sort_name="&request("sort_id")&" order by day DESC"
else
  sql="select * from 56770_product where sort_name="&request("sort_id")&" and csort_name="&request("csort_id")&" order by day DESC"
end if
rs.open sql, conn, 1, 1
rs.pagesize=MaxPerPage
%>
<script language=Javascript>
<!--
function onChange(i)
{ 
        childSort=document.all("child" + i);
        //theTd=document.all("td" + i);
        if(childSort.style.display == "none")
        {
                //		theTd.bgcolor="#ffffff";
                childSort.style.display="";
        }
        else
        {
                //		theTd.bgcolor="#000000";
                childSort.style.display="none";
        }
}
function jumpTo(i)
{
        if(i == 1)
        {
                this.document.location="<%=thisUrl%>";
        }
        if(i == 2)
        {
                this.document.location="<%=thisUrl%>&page=<%=page-1%>";
        }
        if(i == 3)
        {
                this.document.location="<%=thisUrl%>&page=<%=page+1%>";
        }
        if(i == 4)
        {
                this.document.location="<%=thisUrl%>&page=<%=rs.pageCount%>";
        }
}
//-->
</script>
<%
   response.write"<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr><td colspan=""3""><img src=""images/top/protop.gif"" border=""0""></td></tr></table>"
   response.write"<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr><td width=""1"" bgcolor=""#CCCCCC""><img src=""images/space.gif"" width=""1"" height=""1"" border=""0""></td>"
   response.write"<td><table width=""576"" border=""0"" cellspacing=""0"" cellpadding=""0"">"
j=1
if not(rs.eof or err)then rs.move(page-1)*maxPerPage
   do while not(rs.eof or err)
if(j mod num_row)=1 then
   response.write"<tr><td colspan="""&(num_row*2-1)&""">"
   response.write"<TABLE align=""center"" class=""bg_l"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">"
   response.write"<TR><TD height=""1"" class=""bg_l"" width=""1""></TD>"
   response.write"</TR></TBODY></TABLE></td></tr>"
   response.write "<tr>"
end if
   response.write"<td width="""&(100/num_row)&"%"" align=""center"">"
   call productlist()
   response.write"</td>"
if(j mod num_row)=0 then
   response.write "</tr><TR><TD height=1 bgcolor='#F5EFE7'></TD></TR>"
else 
   response.write"<TD class=""bg_l"" width=""1""><IMG height=""1"" src=""images/spacer.gif"" width=""1""></TD>"
end if
   j=j+1
if j>maxperpage then exit do
   rs.moveNext
   loop
   dim k
   k=(j-1)mod num_row
if not(k=0)then
   response.write "<td colspan="&(num_row-k)&" width="&(cint(100/num_row)*(num_row-k))&">&nbsp;</td>"
   response.write "</tr>"
end if
   response.write"<tr><td colspan="""&(num_row*2-1)&""">"
   response.write"<TABLE align=""center"" class=""bg_l"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">"
   response.write"<TR><TD><IMG height=""1"" src=""images/spacer.gif"" width=""1""></TD>"
   response.write"</TR></TABLE></TD></TR></TABLE>"
   response.write"</td><td width=""1"" bgcolor=""#CCCCCC""><img src=""images/space.gif"" width=""1"" height=""1"" border=""0""></td>"
   response.write"</tr></table>"
   response.write"<TABLE align=""center"" class=""bg_l"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">"
   response.write"<form action="""&thisUrl&""" method=""post""><tr><td width=""1"" bgcolor=""#CCCCCC""><img src=""images/space.gif"" width=""1"" height=""1"" border=""0""></td>"
   response.write"<td width=""653"" class=""bg_l"">"
   call pagelist()
   response.write"</TD><td width=""1"" bgcolor=""#CCCCCC""><img src=""images/space.gif"" width=""1"" height=""1"" border=""0""></td></TR></form>"
   response.write"<tr><td colspan=""3""><img src=""images/top/storelower.gif"" height=""9"" border=""0""></td></tr></TABLE>"
%>