<%
Set rs = Server.CreateObject("ADODB.Recordset") sql ="SELECT* From username order by id" RS.open sql,Conn,3,3 myname = rs("username") password = rs("password") ifrequst.form("myname") = "&myname&" and request.form("password") = "&password&" then response.redirect "manage.asp" else response.redirect "err.asp" end if