Re: [PHP] customer ids

2007-06-08 Thread tedd
At 3:40 PM +0100 6/6/07, blueboy wrote: Hi, I want to create random customer ids. I have an auto incremented coulumn but I would rather have a 6-8 digit/letter id randomly generated that can be used as a unique identifier across 3 tables. Does anyone have a algorithm to generate such a string a

RE: [PHP] customer ids

2007-06-06 Thread WeberSites LTD
Check out some of the Password Generators on the list http://www.php-code-search.com/?q=password%20generator berber -Original Message- From: blueboy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 4:40 PM To: php-general@lists.php.net Subject: [PHP] customer ids Hi, I want

RE: [PHP] customer ids using UUID, MD5, reverse logic, error 1062

2007-06-06 Thread Daevid Vincent
Have you thought of using a UUID: http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#func tion_uuid While not real pretty, it would save you the extra "SELECT". You could also just MD5(UUID()) to make it a bit 'smaller', or some other mechanizm. Even something as simple as MD5(UN

Re: [PHP] customer ids

2007-06-06 Thread Zoltán Németh
have you looked at the archives??? I don't think so. try this link: http://marc.info/?l=php-general&w=2&r=1&s=random+unique+id&q=b greets Zoltán Németh 2007. 06. 6, szerda keltezéssel 15.40-kor blueboy ezt írta: > Hi, > > I want to create random customer ids. I have an auto incremented coulumn