Hi all,
I have a system where users can register, but must verify their email addresses by clicking on a confirmation link sent to their email.
I currently have the database set up as follows
tbl_temp_members (confirmcode, firstname, lastname... etc)
tbl_reg_members (userid, firstname etc...