The reason why I used incremental value from the db is that I need a sequence number generator that can be used as an argument to my function. If I can generate sequence number myself, I don't need this incremental value from db. What I want is that the sequential alphanumeric id that increments it's numeric value by one everytime a new record is inserted while the alphabet part remains the same..(like I've shown before): AAA0001 AAA0002 ... AAA0009 AAA0010 This id will be used as the application number that will be printed as a barcode on the user's application form. The requirement says that the app number is prefixed with the letters (actually it's not 'AAA' but 'FIN' which stands for File Identification Number).... tedd-2 wrote: > > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- View this message in context: http://www.nabble.com/Creating-alphanumeric-id-for-a-table-tp25391939p25411503.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
