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 SHA

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-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 i

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 whe