Generating customer id's from the database

[heshan]

Hi all,

 

I want some help regarding my banking project. I have a customer registration form in my project.After successfully completion of the form users have to click on the "Open Account" button.Thereafter a customer id(Auto increment value) should be generated.It was stored in the database where other form details are also being stored. How can i call to this one by one customer id's??

 

Heshan,

[Tonic-_-]

If you are creating a user / client ID automatically with the users table and then when creating a account you should query for the users log in name from the users table and store the Client ID and leave it in a variable that way when they goto create a account you can store the Client ID and a account id (which auto-increments).

 

That's a simple way but may not always be fully optimized for big traffic/usage.

[Pikachu2000]

If you need to get the customer ID as soon as it is inserted into the database (and you're using MySQL), mysql_insert_id().

[heshan]

Thanks for both of the ideas,

 

I have tried but difficult arises with exact codings.

Could you guys please send me full codings regarding this?

 

Heshan,