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.
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!)