0

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

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by public-image
0

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.

Edited by public-image: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.