标题:请各们高手帮忙看下我这问题应该怎么解决
取消只看楼主
爱好者跟
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2011-6-3
结帖率:0
已结贴  问题点数:0 回复次数:1 
请各们高手帮忙看下我这问题应该怎么解决
<div id="container">
        <div class="banner"><img src="images/JD_06.jpg" alt="产品广告图" /></div>
       <%
               sql = "SELECT * FROM P_class ORDER BY p_id"
            Set rs = Server.CreateObject("ADODB.Recordset")
            rs.OPEN sql,Conn,1,1
            if rs.eof and rs.bof then
            else
                do while not rs.eof
                sql = "SELECT * FROM P_class_small where p_id ="&rs("p_type")&""
                Set rs2 = Server.CreateObject("ADODB.Recordset")
                rs2.OPEN sql,Conn,1,1
        %>
        <ul id="product">
                <dl><dt><%=rs("p_name")%></dt></dl>
                <% do while not rs2.eof %>
                       <li><a href='product.asp?classtype=<%=rs2("p_id")%>&smallclass=<%=rs2("p_small_type")%>'><%=rs2("p_small_type")%></a></li>
                    <%
                    rs2.movenext
                    loop
                    rs2.close
                    Set rs2=Nothing
                    %>
              <div style="clear:both; display:none"></div>
       </ul>
           <%
            rs.movenext
            loop
            end if
            rs.close
            Set rs=Nothing
           %>  
        <div id="product_gd">
             <dd><input name="get_up" type="button" id="get_up" /></dd>
            <ul>
                 <marquee direction="up" scrollAmount=4 onMouseOver="this.stop()" onMouseOut="this.start()">
                      <ul id="product_pic" style=" width:130px;">
                    <%  
                    sql = "SELECT top 5 * FROM P_INFO"
                    Set rs3 = Server.CreateObject("ADODB.Recordset")
                    rs3.OPEN sql,Conn,1,1
                    do while not rs3.eof%>
                    
                      <li style="clear:both;"><a href="showprodetail.asp?ProID=<%=rs3("p_id")%>" class="money"><img src="<%=rs3("p_pic")%>" alt="<%=rs3("p_name")%>"  width="107" height="107"/></a></li>
                    <li><A href="showprodetail.asp?ProID=<%=rs3("p_id")%>" class="money"><%=rs3("p_name")%></A></li>
                    <%
                    rs3.movenext
                    loop
                    rs3.close
                    Set rs3=Nothing
                    %>
             </ul>
              </marquee>
            </ul>
          <dd><input name="get_down" type="button" id="get_down" /></dd>
       </div>
        <div style=" clear:both;"></div>
    </div>
搜索更多相关主题的帖子: where 
2011-06-03 14:38
爱好者跟
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2011-6-3
得分:0 
那个图片贴不上来,请高手留个邮箱,具体的我到你邮箱
2011-06-03 14:40



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-341807-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.017516 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved