Doesn't check if username or email exits in database properly

[sunny124]

hi,

I have created a registration form. When the user clicks submit it goes to processRegister.asp. This is where it checks whether the username and email already exits in the database.

When i enter a email that is already in the database, the error message for the email and the username shows up.. Even if i entered a completely new username that is not in the database.

The email error message is working... but why does the username error message show up.

The email's do while loop excutes right after the do while loop for username has executed.

The block of code right towards the bottom excutes in register.asp page.

' code for username loop

Do while not objRegisterRecordSet.EOF
	
	if objRegisterRecordSet("tUserName") = Request.Form("user") then
			 
			 Session("invaliduserName") = true  ' username entered is in database
			 exit do ' exits this loop
			 else
			 UserNamecounter = UserNamecounter + 1  ' username entered was not in that record
		end if
		objRegisterRecordSet.MoveNext ' goes to next record
	Loop

'code for email loop

Do while not objRegisterRecordSet.EOF
	if objRegisterRecordSet("tEmail") = Request.Form("email") then
		
		Session("invalidEmail") = true ' email entered is in database
		exit do ' exits loop
		else
		Emailcounter = Emailcounter +1 ' email entered was not found at this record
	end if
	objRegisterRecordSet.MoveNext ' goes to next record
	Loop

if Session("invalidEmail") = true OR Session("invaliduserName") = true then
	' if username or email entered was found in database go to register.asp page
	Response.Redirect("Register.asp")
	end if

'code for register.asp
<%
	if Session("invaliduserName") = true then
%>
	<p class="InvalidUsernameAndEmailRegisterd"> <% Response.write("The user name entered is already taken... Please choose another user name") %>
	 </p>
	 
<%
		Session("invaliduserName") = false
 		End if %>
 
 <%
		if Session("invaliduserName") = false then
%>
		<p class="InvalidUsernameAndEmailRegisterd"> <% Response.write("")  %></p>
<%

 End if %>
 
 
 <% 
	if Session("invalidEmail") = true then 
%>
<p class="InvalidUsernameAndEmailRegisterd">
	<% Response.Write("The email entered already exist in our database... Either you are already a memeber or you have given an incorrect email. Please enter an correct email please.")
%>
</p>
<% 
	Session("invalidEmail") = false
end if %>

 <%
	if Session("invalidEmail") = false then
%>
	<p class="tabledata"> <% Response.write("")  %></p>
<%

 End if %>