I am developing a MIS for a bank.There i want to create various types of accounts and i want something like this to be done.
Ex: Account type Account Number
A 1001, 1002, 1003, etc
B 2001, 2002, 2003, etc
C 3001, 3002, 3003, etc
Likewise i want to differentiate these accounts with account numbers.I want to know whether i will able to do this in PHP and MySQL and how?
It is possible to generate account numbers like 1,2,3,4,5... etc in my table.
But i am not sure whether i will be able to do more flexible way like shown as above.
Please give me your comments