http://www.zgshpm.com/index.asp?from=zg
这个网页中的搜索代码我不会写,希望有知道的提示一下,小弟在这里谢过了!~~
以下是那段表格的代码,我实在不会加搜索的代码了,希望偶人帮帮忙!~~
<table width="1004" height="26" align="center" background="image/red.jpg">
<tr>
<form name="form" method="post" action="artista2.asp">
<td width="83 "height="18" colspan="2" align="center"> </td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="书法名家">
<font color="#FFFFFF">书法名家</font></td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="国画名家">
<font color="#FFFFFF">国画名家</font></td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="油画名家">
<font color="#FFFFFF">油画名家 </font></td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="根雕名家">
<font color="#FFFFFF">根雕名家</font> </td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="奇石名家">
<font color="#FFFFFF">奇石名家 </font></td>
<td width="83 "height="18" colspan="2" align="center">
<input type="radio" name="radiobutton" value="摄影名家">
<font color="#FFFFFF">摄影名家 </font></td>
<td width="83 "height="18" colspan="2" align="left">
<input type="radio" name="radiobutton" value="鉴定家">
<font color="#FFFFFF">鉴定家</font> </td>
<td width="83 "height="18" colspan="2" align="center">
<input type="text" name="selectkey" id="selectkey" onFocus="this.value=''" value="" size="20">
</td>
<td width="83 "height="18" colspan="2" align="center">
<input class="button" type="submit" name="Submit2" value="搜 索"></td>
<td width="83 "height="18" colspan="2" ></td>
</form></tr></table>
我就知道最基本的搜索
set mycon=server.createobject("ADODB.CONNECTION")
mycon.open.con
%>
<%
set rs=server.createobject("ADODB.Recordset")
rs.open "SELECT*FORM aa where title and word like "&request.form("selectkey")&",MyCon,adOpenStatie
%>
<html><head><title>查询结果</title></head>
<body bgcolor="#ffffff">
<div align="center"><center>
<table border="1" align="center"
bordercolor="000000" berdorcoorlight="#000000"
bordercolordark="#ffffff">
<tr align="center">
<td width="20%" align="center" bgcolor="#ffffff">姓名</td>
<td width="60%" align="center" bgcolor="#ffffff">其他信息</td>
</table>
<table border="1" align="center" bordercolor="000000" berdorcoorlight="#000000" bordercolordark="#ffffff">
<tr align="center">
<!--从数据库提取信息-->
<% while not rs.eof %>
<tr align="center">
<td width="20%" align="center" bgcolor="#ffffff"><% =rs("name") %></td>
<td width="60%" align="center" bgcolor="#ffffff"><% =rs("其他信息") %></td>
<% rs.movenext %></tr><% wend %>
</table>
</center>
</div>
<% rs.close %>
<% mycon.close %>
"关闭链接
</body>
</html>