Handling 2 tables...
I'm looking for some guidance.
I am building a client registration system with the following behaviour...
A New Client completes and submits a 4-field registration form, populating Table A in a mysql database.
During registration, the client selects a value in the status field; either 1 or 2.
When a Registered Client logs in:
If the Status field value = 1, they are redirected (in the normal way) to the profile page and no further behaviour is required.
If the Status field value = 2, as above but an additional 15 fields are shown requiring completion and saving!
Now, the twist here is that these 15 fields exist in Table B of the same database.
- Session values, including a unique user id (from Table A) are captured during login.
- Table B carries a unique user id field
- Table B will only hold 1 record per 'matched' user in Table A
Ideas on how this can be accomplished gratefully received.
Thank you, Paul.