OT1999 Posted January 3, 2014 Report Share Posted January 3, 2014 Hi, i have recently set up a VA and we made a few test accounts and have deleted them, now when we get new members it makes their Pilot ID way higher than the previous one. for example, our highest member id we had was 008 and i had changed him to a lower number to maintain consistency. And today we had someone sign up and the id went to 016. is there any way so that the next person will automatically be set to 009? thanks in advance Oli Trehearne Quote Link to comment Share on other sites More sharing options...
flyalaska Posted January 4, 2014 Report Share Posted January 4, 2014 go to phpmyadmin, go in the pilots table. Click on the operations tab. In the Auto Increment field, change the currant number to 1. Since you have a new pilot since you deleted the others, there is nothing you can do now. You Quote Link to comment Share on other sites More sharing options...
OT1999 Posted January 5, 2014 Author Report Share Posted January 5, 2014 i have done that, thanks, now to wait for a new member to join to test it. 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.