Re: [PHP] Unique ID system - need help/ideas

Wow I think you are on to something!!! I'll give it a whirl! Thanks! --- [EMAIL PROTECTED] wrote: > On 10 Mar 2004 J J wrote: > > > My problem is how do I recreate this in PHP to > make > > sure any newly added records follow this same > unique > > ID? > > I haven't played much with these fun

Re: [PHP] Unique ID system - need help/ideas

On 10 Mar 2004 J J wrote: > My problem is how do I recreate this in PHP to make > sure any newly added records follow this same unique > ID? I haven't played much with these functions but I think for MySQL you'd want something like this, for the state "XX" (excuse the wrapped lines):

RE: [PHP] Unique ID system - need help/ideas

Yeah thanks for the feedback, I'm already including a primary key auto_increment field in place to tie the tables together with an ID I *know* will be unique. This other ID scheme is just to work within their existing system that uses this. I'm just trying to mirror/maintain that scheme for their

RE: [PHP] Unique ID system - need help/ideas

At 04:10 PM 3/10/2004 -0800, Chris W. Parker wrote: J J on Wednesday, March 10, 2004 4:03 PM said: > I'd like to keep it in one field if possible since > that's how their database is now and data will be > going back and forth. [snip] > So any state with more than on

RE: [PHP] Unique ID system - need help/ideas

J J on Wednesday, March 10, 2004 4:22 PM said: > Will it be able to figure out what the last number is > if it's a character type and the number is something > like 3? So it'll add one to make it 4 and not > something like 10003. php knows. you'll just have

RE: [PHP] Unique ID system - need help/ideas

Will it be able to figure out what the last number is if it's a character type and the number is something like 3? So it'll add one to make it 4 and not something like 10003. ?? --- "Chris W. Parker" <[EMAIL PROTECTED]> wrote: > > yeah that makes sense. hmm.. well i'll give you my > ide

RE: [PHP] Unique ID system - need help/ideas

J J on Wednesday, March 10, 2004 4:03 PM said: > I'd like to keep it in one field if possible since > that's how their database is now and data will be > going back and forth. [snip] > So any state with more than one record can be > sequential and not jump around l

RE: [PHP] Unique ID system - need help/ideas

I'd like to keep it in one field if possible since that's how their database is now and data will be going back and forth. Plus there should be allowed two of the same numbers, so like: AL3 KY3 So any state with more than one record can be sequential and not jump around like KY3, AL0

RE: [PHP] Unique ID system - need help/ideas

J J on Wednesday, March 10, 2004 3:46 PM said: > Any ideas? Thank you in advance! does it all have to be in the same field? can you not just combine two fields? one field would be called 'id' and it would be auto-incrementing. second field would be 'state' and it w