Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if user AND email exists...Then..

Status
Not open for further replies.

Sajtz

IS-IT--Management
Apr 23, 2002
75
EU
To create a new member I'm using a form where the user should provide information such as username, password, email address and more.
This information must be compared to the current information in the database table, because I don't want a new user to register with same email address and username as anyone else.

How can I compare the email address and the username from the form to the information in the database table?
 
U have to open a recordset of a query which U compare user's emailAdd, or username , etc.
and If your recordset has one of more records, then you have one or more matched data in your database.


:eek:)*JJ26*:eek:)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top