TalkPHP - View Single Post

marxx · 03-09-2008, 02:45 PM

Hi all!

Today my problem is to generate unique ID which contains numbers and letters (ie. 101MH).

As far as I know (well, i don't know much tho), mysql wont let use auto-increment with letters? So, here is couble thoughts what came up but don't quite know how to make these.

First, script checks all IDs from database and picked up biggest ID.

Code:

100MH
101MH
102MH
103MH <- this one

after that, we would use that, explode it and increase that number to 104, add MH again to it and use it as new unique ID.

Second thing what came in my mind was use do while??

So if someone has some suggestions, please could you share it for me? =)

And I know, would be simple to NOT use those letters but I have my reasons! ;)

Thanks for all help (again!)

03-09-2008, 02:45 PM	#1 (permalink)
marxx The Contributor Join Date: Sep 2007 Location: Finland Posts: 45 Thanks: 3	unique ID whit numbers and letters? Hi all! Today my problem is to generate unique ID which contains numbers and letters (ie. 101MH). As far as I know (well, i don't know much tho), mysql wont let use auto-increment with letters? So, here is couble thoughts what came up but don't quite know how to make these. First, script checks all IDs from database and picked up biggest ID. Code: 100MH 101MH 102MH 103MH <- this one after that, we would use that, explode it and increase that number to 104, add MH again to it and use it as new unique ID. Second thing what came in my mind was use do while?? So if someone has some suggestions, please could you share it for me? =) And I know, would be simple to NOT use those letters but I have my reasons! ;) Thanks for all help (again!)