list.asp

一个ASP做的购物车

									rs2.open "select * from wq_sort where anclassid="&rs("anclassid"),conn,1,1
									if rs2.recordcount>0 then
									response.write "<a href=class.asp?id=big&anid="&rs2("anclassid")&" targer=_blank>"&rs2("anclass")&"</a>>>>>"
									end if
									rs2.close
									set rs2=server.createobject("adodb.recordset")
									rs2.open "select * from wq_sort2 where nclassid="&rs("nclassid"),conn,1,1
									if rs2.recordcount>0 then
									response.write "<a href=class.asp?id=small&anid="&rs2("anclassid")&"&nid="&rs2("nclassid")&" targer=_blank>"&rs2("nclass")
									end if
									rs2.close
									set rs2=nothing%>
                        </td>
                      </tr>
					  <tr> 
                        <td>【评分星级】 
                          <%if rs("pingjizong")>0 and rs("pingji")>0 then
								xx=rs("pingjizong")\rs("pingji")
								else
								xx=5
								end if
								response.write "<img src=images/pingji/"&xx&".gif alt=评论星级>"%>
								<BR>　　　　　　有<%=rs("pingji")%>位网友评论
						 </td>
                      </tr>
                    </table>
                    <table height="80">
                      <tr> 
                        <td width="221"align="center" valign="bottom"><a href="javascript:;" onClick="javascript:window.open('shopcart.asp?id=<%=rs("bookid")%>&action=add','gouwu','width=450,height=300,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');"><img src="images/shopcart2.gif" width="100" height="36" border=0></a>　<a href="javascript:;" onClick="javascript:window.open('favorites.asp?id=<%=rs("bookid")%>&action=add','shouchang','width=450,height=350,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');"><img src="images/Favorites2.gif" width="100" height="36" border=0></a></td>
                      </tr>
                    </table>
					</td>
                </tr>
              </table>
			  <br> <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td background="images/bj_x1.gif" height="1"></td>
                </tr>
                <tr>
                  <td>
				   <table width="95%" height="37" border="0" align="center" cellpadding="0" cellspacing="0">
                      <tr>
                        <td background="images/view0.gif"></td>
                      </tr>
                    </table>
                    <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
                      <tr>
                        <td><br><%=Code_Ubb(rs("bookcontent"))%><br>
                          </td>
                      </tr>
                    </table>
                    </td>
                </tr>
              </table>
            </td>
          </tr>
          <%
rs.close
set rs=nothing
%>
          <tr> 
            <td>&nbsp;</td>
          </tr>
          <tr> 
            <td height=1 background="images/bj_x1.gif"> </td>
          </tr>
          <tr> 
            <td height="37" background="images/review.gif"></td>
          </tr>
          <%
		set rs=server.createobject("adodb.recordset")
		rs.open "select  * from wq_review where bookid="&request("id")&" and shenhe=1 order by pinglundate desc",conn,1,1
		j=rs.recordcount
		plcount=rs.recordcount
		if j>3 then j=3
		for i=1 to j
%>
          <tr> 
            <td> 
              <table width="100%" border="0" cellspacing="0" cellpadding="2">
                <tr> 
                  <td width="5%" align="right" height="22"><img src="images/image002.gif" width="15" height="15"></td>
                  <td colspan="2" height="22"><b>主题：</b><a href="javascript:;" onClick="javascript:window.open('pinglunll.asp?id=<%=rs("pinglunid")%>','pinglun','width=300,height=400,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no');return false;" title="<%=trim(rs("pingluntitle"))%>"><%=trim(rs("pingluntitle"))%></a></td>
                  <td width="36%" height="22"><img src="images/pingji/<%=rs("pingji")%>.gif" width="79" height="14"></td>
                </tr>
                <tr> 
                  <td width="5%">&nbsp;</td>
                  <td colspan="2"><b>作者：</b><%=trim(rs("pinglunname"))%>　(<%=trim(rs("pinglundate"))%>)</td>
                  <td width="36%"><%=trim(rs("ip"))%></td>
                </tr>
                <tr> 
                  <td width="5%">&nbsp;</td>
                  <td colspan="3">&nbsp;&nbsp;
                    <%if len(rs("pingluncontent"))>24 then 
							  response.write left(rs("pingluncontent"),20)&"... <a href=""javascript:;"" onClick=""javascript:window.open('pinglunll.asp?id="&rs("pinglunid")&"','pinglun','width=300,height=400,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&trim(rs("pingluntitle"))&">[详细内容]</a>" 
							  else response.write rs("pingluncontent")
							  end if%>
                  </td>
                </tr>
                <%if trim(rs("huifu"))<>"" then%>
                <tr> 
                  <td width="5%"></td>
                  <td colspan="3"><b><font color="#0099CC">管理员回复：</font></b><%=rs("huifu")%> 
                  </td>
                </tr>
                <%end if%>
                <tr>
					<td height=1 colspan=4 background="images/bj_x.gif"></td>
                </tr>
              </table>
            </td>
          </tr>
          <%	
		rs.movenext
		next
		if plcount>0 then 
  %>
          <tr> 
            <td align=right height="22"><a href=list_review.asp?id=<%=request("id")%>>　浏览该商品的全部评论</a>　　<font color="#999999">共<%=plcount%>条</font></td>
          </tr>
          <%end if%>
          <tr> 
            <td background="images/bj_x.gif" height="1" ></td>
          </tr>
          <tr> 
            <td align="center" height="38"> <a href="javascript:;" onClick="javascript:window.open('info_recommend.asp?id=<%=request("id")%>','pingluntj','width=325,height=200,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no')"><img src="images/tj.gif" width="60" height="19" border=0></a> 
              <a href="javascript:;" onClick="javascript:window.open('review.asp?id=<%=request("id")%>','pinglun','width=295,height=325,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=no');"><img src="images/pl.gif" width="60" height="19" border=0></a> 
            </td>
          </tr>
        </table>
      </div>
    </td>
    <td width="1" valign="top" background="images/bj_x.gif"></td>
    <td width="178" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 	
	 <%'--会员登陆--%>
	 <%if request.cookies("cnhww")("username")="" and request.cookies("cnhww")("shjianame")="" then%>
      <!--#include file="info_user.asp"-->
	  <%elseif request.cookies("cnhww")("username")<>"" then%>	  <!--#include file="info_history.asp"-->
      <%end if%>
	  <%'--登陆结束--%>
      <!--#include file="info_brand.asp" -->
      <!--#include file="info_market.asp"-->
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td background="images/bj_x.gif" height="1"></td>
        </tr>
        <tr> 
          <td height="22"><img src="images/main/yqgg.gif" width="178" height="34"> 
          </td>
        </tr>
        <tr> 
          <td height="1" background="images/bj_x.gif"></td>
        </tr>
        <tr> 
          <td> 
            <table width="178" border="0" cellspacing="0" cellpadding="0" height="68">
              <tr> 
                <td height="65" width="181"> 
                  <table width="96%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td> 
                        <div align="right"><a href=<%=gg3url%> target="_blank"><img src=<%=gg3%>  border="0" width="166" height="55"></a></div>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
              <tr> 
                <td height="65"> 
                  <table width="96%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td> 
                        <div align="right"><a href="<%=gg4url%>" target=_blank><img src="<%=gg4%>" border="0" width="166" height="55"></a></div>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <!--#include file="info_vote.asp"-->
    </td>
  </tr>
</table>
<!--#include file="webfoot.asp"-->
</body>
</html>