RE: Best options for unique string

2004-08-04 Thread Peter Lovatt
HI MD5 would be a good way of doing it. Just add a column to your user table and UPDATE users SET subscribed = 0 WHERE encryptedID = md5 hash here HTH Peter -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 03:37 To: MySql Subject: Best

Re: Best options for unique string

2004-08-04 Thread Eamon Daly
Hashing algorithms like MD5 are good answers to what you're looking for, but first, I'd recommend SHA1. MD5 is known to have some weaknesses, and SHA1 produces a longer, more secure 160-bit string (called a message digest). MySQL versions 4.0.2 and up have SHA1 built-in. Whether you use MD5 or

Re: Best options for unique string

2004-08-03 Thread Rhino
- Original Message - From: Scott Haneda [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 10:37 PM Subject: Best options for unique string I am building a mailing list manager, using mysql 4 at the moment. I want to have a simply web interface where one

Re: Best options for unique string

2004-08-03 Thread mos
At 09:37 PM 8/3/2004, Scott Haneda wrote: I am building a mailing list manager, using mysql 4 at the moment. I want to have a simply web interface where one can remove themselves from a mailing list. This will most likely be supplied as a link in a email that will be sent to them when they email