Re: Creating a unique index ID

From: Date: Wed, 15 Mar 2006 13:51:33 +0000
Subject: Re: Creating a unique index ID
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-231937@lists.php.net to get a copy of this message
tedd wrote:
Hey all, I've got a project where I'm taking form information from the user and writing records to several tables in a MySQL database. The problem I'm having is I need to write a unique number for the ID column of the records. Auto increment won't work because I could have conflicts due to replication of the database servers. Anyone have any techique they use for creating unique ID field entries in a db table? I was thinking maybe using a random 3 digit number and a unix timestamp? Jeff
Jeff: Look into getmypid() and uniqid() or combine the two.
How about using a DB abstraction layer that provides its own method of implementing sequences? Wouldn't this take away the auto_increment problem?

« previous php.general (#231937) next »