Re: Creating alphanumeric id for a table

I agree that this question could be just "how to create an unique ID with leading letters like 'AAA'. At that point I want to mention that a timestamp does garanty a unique number at almost 100% formated with the given samples in the other posts will do the job. "tedd" <tedd.sperling@gmail.com> wrote in message news:p06240805c6cff752b9f7@[192.168.1.102]... > At 3:17 PM -0700 9/10/09, aveev wrote: > >I want to create user generated id like this : > >AAA0001 > >AAA0002 > >... > >AAA0009 > >AAA0010 > > > >where the id consists of 3 alphanumeric characters and 4 numerical digits in > >the beginning (for numerical digit, it can grow like this AAA10001). I try > >to use php script to generate id like this, where I use the following > >script. > > > ><? > > function generate_id($num) { > > $start_dig = 4; > > $num_dig = strlen($num); > > > > $id = $num; > > if($num_dig <= $start_dig) { > > $num_zero = $start_dig - $num_dig; > > > > for($i=0;$i< $num_zero; $i++) { > > $id = '0' . $id; > > } > > } > > $id = 'AAA' . $id; > > return $id; > > } > > > > $app_id = generate_id(1); > > > >?> > > > >I assume that I can get increment value/sequence from db (I used harcoded > >increment value in the code above (generate_id(1))), > >but I don't know how I can get this incremental value from db.I use mysql > >5.0. > >Or has anyone had another solution to create this alphanumeric id ? > > > >Any help would be much appreciated > >Thanks > > aveev: > > Why get an incremental value from the database? What information does > that give you? Why do you want it? And what are you going to do with > it? > > When those questions are answered, then we can help with more informed advice. > > Cheers, > > tedd > > -- > ------- > http://sperling.com > http://ancientstones.com > http://earthstones.com