28,409
社区成员




<!--#include file="top.asp" --> 'TOP.asp中已经做好了数据库路径
<%
id=request("id")
names=request("names")
set rs=server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM qz_rencai WHERE id="& id &" OR [names] like'%names%' desc"
response.write sql&"<br>"'把这个打印出来的语句放到数据库查询里走一下,看看正确吗?成功后注释掉
rs.open sql,conn,1,1
if rs.eof then
response.write("无记录")
rs.close: set rs=nothing
conn.close: set conn=nothing
response.end
end if
%>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolordark="#FFFFFF">
<tr>
<td width="79"> <%=rs("id")%> </td>
<td width="615"> <%=rs("names")%> </td>
</tr>
</table>
<%
rs.close: set rs=nothing
rs.close: set rs=nothing
%>