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 in and request info about a mailing list. What I don't want is to have a link like [EMAIL PROTECTED] but would rather mask that email address as a unique string.
I was thiking that on INSERT I can use a timestamp with some random and that should be pretty much guaranteed to be unique, I could just use the PK but then people could fiddle the url and mess with others accounts. So I need something non sequential, rather random looking at least, perhaps somehow make mysql case sensitive on this one as well. (How does one make mysql case senseitive on a field?) Would MD5(user_email_address) pretty much be what I am after? I don't suppose there is any way to "un-MD5" something? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
