search.asp

ASP入门与提高实用教程 源文件(上传网站)

<!--#include file="top.asp"-->
<center>


<table border="0" width="760" cellspacing="0" cellpadding="0" height="312">
  <tr>
    <td width="190" height="312" valign="top" align="left">
    <table border="0" width="190" cellspacing="0" cellpadding="0">
      <tr>
        <td width="190" valign="top" align="left"><!--#include file="left.asp"--></td>
      </tr>
    </table>
    </td>
</center>
    <td width="380" valign="top" align="left">
    <table border="0" width="380" cellspacing="0" cellpadding="0" height="5">
      <tr>
        <td width="380" bgcolor="#FF9A31" height="18" colspan="2">
        搜索结果
        </td>
      </tr>
      <tr>
  <td width="100%" bgcolor="#63CFFF" colspan="2" height="1"></td>
      </tr>

<center>
    <%sort_id=request("sort_id")
    hw_name=request("hw_name")
    sql="select * from hw where sort_id='"&sort_id&"' and hw_name like '%"&hw_name&"%' order by hw_id DESC"
    rs.open sql,conn,3,3
    if rs.eof then
    %>

<tr>
  <td width="100%" colspan="2">没有你要找的商品，请先确定商品的类别</td>
</tr><%else%>
<tr><td width=50%>商品编号</td><td width=50%>商品名称</td></tr>
<%do while not rs.eof %>
<tr><td width=50%><%=rs("hw_id")%></td><td width=50%><a href="views.asp?hw_id=<%=rs("hw_id")%>"><%
name=rs("hw_name")
name=replace(name,hw_name,"<font color=red>"&hw_name&"</font>")
response.write name
%></a></td></tr>
<%rs.movenext
loop
end if
rs.close
%>
      </table>
    </center>
    </td>
    <td width="190" valign="top" align="left">
    <table border="0" width="190" cellspacing="0" cellpadding="0">
      <tr>
        <td width="190"><!--#include file="right.asp"--></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
<!--#include file="copy.asp"-->