Question

asp实现数据库分类查找

Answer 1

<%
set rs=server.createobject("adodb.recordset")
sql="select * from admin where admin_name <>''and admin_pwd<>''"

if request("admin_name ")<>"" then sql=sql+" and admin_name ='"&request("admin_name ")&"'"
if request("admin_pwd")<>"" then sql=sql+" and admin_pwd='"&request("admin_pwd")&"'"

if request("admin_name")<>"" then sql=sql+" and admin_namelike '%"&Trim(request("admin_name"))&"%'"
sql=sql+" order by adddate desc"
rs.open sql,conn,1,1
%>

用这样的方法来读取数据库内的内容吧,你要查询某项时,你一定要给它一个东西啊.
就一定要用的IF语句...