title: how to display the username after login instead of login and register form
body: <p>i have created a login page using ASP classic.</p>
  
  <p>The problem is that after the login it redirect to the index page with the same login and register button  instead of display the username or email id?</p>
  
  <p>Thanks in advance...</p>
  
  <p>Here is the code(VBScript).</p>
  
  <pre><code>&lt;%
  email = ""
  password = ""
  ErrorMessage = ""
  
  if request.form &lt;&gt; "" then
  email = Request.Form("email")
   password = Request.Form("password")
  
   if email = "" or password = "" then
   ErrorMessage = "You must specify a username and password."
   else
  set conn = Server.CreateObject("ADODB.Connection")
  conn.Provider = "Microsoft.Jet.OLEDB.4.0"
   conn.Open("F:\main\main\App_Data\Users.mdb")
   set rs = Server.CreateObject("ADODB.recordset")
  rs.Open "Select * FROM Login WHERE Email = '" &amp; email &amp; "'", conn
   response.write("email")
  
  if rs.EOF = false then 
  
   if rs.fields("Password") = password then
    Response.Redirect("indexs.asp")
  
  end if
   end if 
  ErrorMessage = "Login failed"
  end if 
  end if
  
  if ErrorMessage &lt;&gt; "" then
  response.write("&lt;p&gt;" &amp; ErrorMessage &amp; "&lt;/p&gt;") 
   response.write("&lt;p&gt;Please correct the errors and try again.&lt;/p&gt;") 
  
  end if
  %&gt;
  </code></pre>