关于搜索的问题，请各位朋友帮忙下

search.asp代码

google_ad_width = 250; google_ad_height = 250; google_ad_format = "250x250_as"; google_color_url = "000000";

<!--#include file="conn.asp"-->

<%

id=request("id")

if trim(request("keyword"))<>"" then "获得搜索关键词

kword=trim(request("keyword"))

sql="select name,id,time,part from works where name like "%"&kword&"%" or time like "%"&kword&"%" or part like "%"&kword&"%" order by id desc" "按照ID字段倒序排列

else

sql="select name,id,time,part from works order by id desc"

end if

set rs=server.CreateObject("Adodb.recordset")

"response.write sql

rs.open sql,conn,1,3 %>

搜索结果<a href="see.asp?id=<%=rs("id")%>" target="_blank"><%=rs("name")%></a>

see.asp代码

<!--#include file="conn.asp"-->

<%

id=request("id")

set rs=server.CreateObject("adodb.recordset")