Re: Random Unique ID
| From: | tedd | Date: | Thu, 22 Mar 2007 15:24:10 +0000 |
| Subject: | Re: Random Unique ID | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-251093@lists.php.net to get a copy of this message | ||
At 11:18 AM -0600 3/21/07, ccspencer@softhome.net wrote:
Hello, I want to add a random unique ID to a Mysql table. Collisions are unlikely but possible so to handle those cases I'd like to regenerate the random ID until there is no collision and only then add my row. Any suggestions for a newbie as to the right way to go about doing this? Best, CraigCraig: Simple. Generate a "random unique ID" via whatever method you want. However, before using, search your dB to see if it's already in use. If it is, then generate another one and repeat. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com