productsleft.asp

管理登录system 管理员：admin 密码：admin888 数据库链接文件： conn.asp 内容数据库前台链接文件 systemconn.asp 内容数据库后台链接文件 sy

<table width="100%" border="0" cellspacing="0" cellpadding="0" class="Index-Left-Bot">
  <tr>
    <td height="22" bgcolor="#DEDEDE"><img src="Images/Products_Left_Title.gif" alt="信息检索" width="190" height="32" /></td>
  </tr>
  <tr>
    <td height="84" align="center" bgcolor="#f2f2f2"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="Page-Left-01">
      <tr>
        <td height="12"></td>
        <td></td>
        <td colspan="2"></td>
      </tr>
<%
set RsA = server.createobject("adodb.recordset") 
RsA.source = "select id,parentid,content from deeptree where parentid=0 order by id"
RsA.open RsA.source,conn,1,1
if RsA.eof then response.write"还没有相关内容！" 
while not RsA.eof
   Pid=RsA("id")
%>
      <tr>
        <td width="30" height="21">&nbsp;</td>
        <td width="24"><img src="Images/Arrow-Page-01.gif" width="13" height="13" /></td>
        <td colspan="2"><a href="ProductsListA.asp?id=<%=RsA("id")%>&Str=<%=RsA("content")%>"><%=RsA("content")%></a></td>
      </tr>
      <%
         set RsB = server.createobject("adodb.recordset")
         RsB.source = "select id,parentid,content from deeptree where parentid="&Pid&""
         RsB.open RsB.source,conn,1,1
         while not RsB.eof
         %>
      <tr>
        <td height="21">&nbsp;</td>
        <td>&nbsp;</td>
        <td width="24"><img src="Images/Arrow-Page-01.gif" width="13" height="13" /></td>
        <td><a href="ProductsListB.asp?id=<%=RsB("id")%>&Str=<%=RsB("content")%>&Pid=<%=Pid%>&PStr=<%=RsA("content")%>"><%=RsB("content")%></a></td>
      </tr>
      <%
            RsB.movenext 
         wend
         RsB.close
         set RsB=nothing
'========
RsA.movenext
wend
RsA.close
set RsA=nothing
%>
      <tr>
        <td height="12"></td>
        <td></td>
        <td></td>
        <td></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td bgcolor="#DEDEDE"><img src="Images/Search_Left_Title.gif" alt="快速查看" width="190" height="30" /></td>
  </tr>
  <tr>
    <td height="88" align="center"><table width="142" border="0" cellspacing="0" cellpadding="0">
        <form action="Search.asp" method="post" name="SearchForm" id="SearchForm">
          <tr>
            <td width="48" height="24">关键字：</td>
            <td height="24" colspan="2"><input name="KeyWord" type="text" id="KeyWord" size="11"  class="Index-Left-TextInput"/></td>
          </tr>
          <tr>
            <td height="24">范　围：</td>
            <td width="63" height="24"><select name="Area" class="Index-Left-TextInput" id="Area">
                <option value="None" selected="selected">请选择</option>
                <option value="Pro">产品</option>
                <option value="News">新闻</option>
                <option value="Down">下载</option>
                <option value="Require">需求</option>
                <option value="Feedback">留言</option>
              </select>
            </td>
            <td width="20" height="24" align="right"><input name="SubmitSearch" type="image" src="Images/Index_Left_Go.gif" width="18" height="18" border="0" /></td>
          </tr>
        </form>
    </table></td>
  </tr>
  <tr>
    <td bgcolor="#DEDEDE"><img src="Images/Index_Left_Quick.gif" alt="快速查看" width="190" height="30" /></td>
  </tr>
  <tr>
    <td height="88" align="center"><table width="100" border="0" cellspacing="0" cellpadding="0" class="Index-Left-Bot1">
        <tr>
          <td width="24" height="21"><img src="Images/Arrow-IndexLeftQuick.gif" alt="信息检索" width="13" height="13" /></td>
          <td width="76" height="21"><a href="ProductsQuick.asp?Action=RECOM">推 荐 产 品</a></td>
        </tr>
        <tr>
          <td height="21"><img src="Images/Arrow-IndexLeftQuick.gif" alt="信息检索" width="13" height="13" /></td>
          <td height="21"><a href="ProductsQuick.asp?Action=HOT">热 门 产 品</a></td>
        </tr>
        <tr>
          <td height="21"><img src="Images/Arrow-IndexLeftQuick.gif" alt="信息检索" width="13" height="13" /></td>
          <td height="21"><a href="ProductsQuick.asp?Action=NEW">新 出 产 品</a></td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td height="30" bgcolor="#f2f2f2">&nbsp;</td>
  </tr>
</table>