Sounds like ya wanna use a database that supports transactions, PostgreSQL supports it. I'm kinda new to this so I'd check it out but I think this could be what yer after. Cheers, Graeme :) ----- Original Message ----- From: "Dewi Wahyuni" <xueh@lycos.com> To: <php-db@lists.php.net> Sent: Tuesday, June 03, 2003 4:47 AM Subject: Reserve Username while Confirming Signup > Hi All, > > I have a sign up page and when the user submit, it goes to a confirmation page, before the person actually submits. > > The confirmation page stores the username and password in the Session variable and the submit page stores it into the database by getting it from the session. The rest of the information (eg. address) is resubmited via hidden input type. > > The question is : I want to reserve the username for the person(say A) while he/she is in the confirmation page and perhaps going back to edit some stuff. What is the best way to do that? > > > I tried putting it in my database in a Logintemp table. With the same fields as the Login table. When the user submits, the Logintemp contents is moved to the Login table. > > The problem is what if while A is staring at the screen the computer hangs. How do I know if he/she closes the page altogether. I need to delete the contents of Logintemp since it was not moved to Login. > > Is there any other better way to do this? > > > ____________________________________________________________ > Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! > http://login.mail.lycos.com/r/referral?aid=27005 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
