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 etc)
Once signed up, the details are entered into temp members
tbl_temp_members --> then copied into tbl_reg_members once account is confirmed.
My question is, is this the best/most common way for account creation & confirmation. Would it be advised to just have 1 table consisting of all accounts, with a field called "confirmed" set to yes/no accordingly?
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 etc)
Once signed up, the details are entered into temp members
tbl_temp_members --> then copied into tbl_reg_members once account is confirmed.
My question is, is this the best/most common way for account creation & confirmation. Would it be advised to just have 1 table consisting of all accounts, with a field called "confirmed" set to yes/no accordingly?