I want to log a user into my site, once they have correctly entered their user PIN, and LAST_NAME they'll click the submit button, and all the data for that person is displayed. If thy choose to make an address change on the second page I would like to give them a pdf with the address changed data inserted and in the same letter head as we currently use.
I can get the login to work, but can't seem to get the detail to work. And one reason is maybe that I am using Dreamweaver instead of writing the code myself however, (and there is one of these always) I have to pull the data from lots of tables.
So here is what I think I have to do,
1.) Start a session and hold that session until the browser is closed or set for a determined timed-out.
2.) Have the detail page use the PIN as the session varible, and allow it to display the detail data.
3.) Have a form in the address area that displays the current address, but when it is changed provide an update button that will print the new PDF form so it can be mailed in to the office and a Counsler. ONLY the address will be alowed to get changed and it isn't to update the MySQL databse.
What do you think?
Also do you know anything out there to help randomly generate a 6 digit PIN that is not repeated and can be inserted into a MySQL database?
Thanks for any and all help on this small project.