I was given a database that has uniques IDs such as: AL00001 AL00002 AR00001 AR00002 MI00001 etc...
The first two letters are based on the state they live in, then it would need to look at the next 5 characters to determine the next ID. My problem is how do I recreate this in PHP to make sure any newly added records follow this same unique ID? So if I insert another Alabama record the id would be: AL00003 Or insert a record from a new state would be: NY00001 (so NY00000 is the default starting point) Any ideas? Thank you in advance! __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
