andrewholway Posted January 15, 2007 Share Posted January 15, 2007 Hi, Im trying to create a form that submits customer details to a database. The input part all works okay. I want each customer to have a unique sequential ID. in the DB at the mo I have 001,002,003,005,006 so I would want it to use 004 or 007 if 004 has been used. Any Ideas on how I should go about this. I tried google but Im unsure on the search terms to use.Cheers,Andy Quote Link to comment Share on other sites More sharing options...
btherl Posted January 15, 2007 Share Posted January 15, 2007 For mysql, the search term to use is AUTO_INCREMENTHope that helps :) Quote Link to comment Share on other sites More sharing options...
andrewholway Posted January 15, 2007 Author Share Posted January 15, 2007 Just the ticket! Cheers 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.