Is there any way to create account numbers like this?

[heshanm]

Hi all,

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

Thanks,
Heshan

[public-image]

To have a unique ID for every account you would create a table in MYSQL and a table column (e.g. id) would have to be primary key and auto increasement this would make every row go up by 1 e.g. 1,2,3,4

I am not sure what your trying to ask I think you are saying for each account type has a specific row number...
E.g. A = 1000, 1001 etc...
E.g. B = 2000, 2001 etc...
due to these numbers increasing there is a possibility of overwriting rows and so each account type would have its own table, that is if that is what you were asking.

There may be other ways although I only know that way.