Registration Form

[MValentine]

I have a preregistration form on a web site that gathers most of the information about an instructor. This information goes into the instructors table in a mySQL database. After his or her credentials are confirmed, I would like to send the instructor a registration form that basically allows them to choose a username and password. The form has 5 fields: first and last name, username, password, and confirm password. This is really a form with an update record behavior that has the instructor's first and last name already displayed on the form when it's sent to him or her and all the instructor needs to do is to add a username and password (and confirm the password). However, I cannot use the Check New Username with an Update Record behavior, it needs an Insert Record behavior. (I am using php.) Can I use both Update and Insert Record behaviors on the same form with the same table? I tried and I am having some problems. I also tried putting the membership info in a separate table, and that seem to work well except I had great difficulty writing a SQL statement that would display fields from two tables without getting duplicates (and no one offered any help on any my past postings).

There have been a lot of people viewing my posts but no one stopping by to offer any help. Even if someone can point me in the right direction, I would greatly appreciate it!

[Creativ_Technologies]

I think you are approaching this in the wrong way. What I would do is have them setup a username and password first and use the "insert" behavior first. This will let you uniquely identify the user to get the correct records. Then when they register their username/password, have them redirected to the other form. This is where you would use the update server behavior. Be sure to check on login if they have completed this form or not, that way they are not redirected to this form everytime they log in. Maybe put a column in the DB named regComplete with the initial value of 0, then when tnhey have completed the registration form, update the value ot 1. Then on login, say "IF the regComplete is 1 then redirect to the home page or whatever, else redirect to the registration form."

[MValentine]

Thanks for your response. I think in my particular case, I want the registration form to be the username and password. I actually had it working when I put the the membership info into a separate table. That allowed my to use the Insert Record behavior successfully with just those fields. It worked well but when I created a report or a membership page to display the membership info, I got a lot of duplicates and some odd behavior. I main problem is that I am new to php and mySQL. So, I decided to hit the books and get a better grasp on the programming.

Thank you very much for your help and comments. I learned from them!