jim... pretty much what i had thought about... question.. how does one correctly!!! set up a cron process... i assume that i can write a quick perl/php app that iterates through the 'emailconfirmTBL' looking at the date, and the confirm status. if the cleanup app sees any records that are over a certain age, and haven't been confirmed, it can simply delete the record. but shouldn't the cleanup also do a rollback/delete of the user registration records as well... this kind of approach would lend itself to being monitored by an admin who could then look to see where in the process a given user is/was... any good/quick guides you can point me to! thanks -bruce -----Original Message----- From: Jim Moseby [mailto:JMoseby@xxxxxxxxxxxxxxxxx] Sent: Monday, September 12, 2005 8:56 AM To: 'bedouglas@xxxxxxxxxxxxx'; php-general@xxxxxxxxxxxxx Subject: RE: confirmation email script/code > has anybody come across a really good 'open source' chunk of code for > sending/recieving confirmation emails from an app... i'd like > to allow the > user to register, and send them an email that they then have > to hit the link > to complete the process.. It is strightforward to write this yourself. In my simple example, I generate a 32 byte random ID when the user registers and save it along with his data in the DB. Then, I send him an email with a link like this: www.example.com/register.php?id=7H7dh869ha320J6GhAs89L0lJ00j09df?action=conf irm When he clicks the link, I flip a flag in his DB record that he has confirmed. I have cron periodically go and clean up unconfirmed records that have timed out. JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php