The Plan

Here is the plan of attack to validate members -

1. The person signs up and their info is added to the database, however their account is marked as 'not validated' and cannot log-in until it is 'validated'.
    

2. An email is sent to them with a link that contains their email and an activation code.
    

3. They click on this link and are transported to a page
    

4. The page takes those two values and looks them up in the database to mark their account as 'validated'

The database will look something like this -

Table Name : Users
ID	Username	Password	Email	Status
Primary Key, Auto Number	Must be unique. Text	Text	Must be unique, text	Text, either V (validated) or N (not validated)

The form -

Form Name : NewUser
UN	PWD	EM
Username field.	Password field.	Email field.