heshan Posted August 1, 2010 Share Posted August 1, 2010 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, Quote Link to comment Share on other sites More sharing options...
Tonic-_- Posted August 1, 2010 Share Posted August 1, 2010 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. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted August 1, 2010 Share Posted August 1, 2010 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(). Quote Link to comment Share on other sites More sharing options...
heshan Posted August 2, 2010 Author Share Posted August 2, 2010 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, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.