Moderators servetas Posted July 28, 2010 Moderators Report Share Posted July 28, 2010 Hello, Yesterday a pilot register to Greece AIrways VA and he requests from me to change his pilots id.I make his pilot id from GRW042 to id GRW312.But after that i saw but there would be some problem so i change again the pilots id from GRW312 to GRW042.But now when a user register with my company his pilot id is the GRW313,GRW314,GRW315,GRW316.How can i set the system when a pilot register with us his pilots id will be the GRW043,GRW044,GRW045,GRW046? Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted July 28, 2010 Administrators Report Share Posted July 28, 2010 Once you change the ID to a higher one, it starts from there... there's a warning about it Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted July 28, 2010 Author Moderators Report Share Posted July 28, 2010 so i cannot make the pilot id starts again from GRW043? Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted July 28, 2010 Report Share Posted July 28, 2010 you would have to change all pilotids above where you want to continue at to below that point and then reset your auto-increment number in phpadmin to the highest pilotid +1. Quote Link to comment Share on other sites More sharing options...
dimitris Posted July 28, 2010 Report Share Posted July 28, 2010 you would have to change all pilotids above where you want to continue at to below that point and then reset your auto-increment number in phpadmin to the highest pilotid +1. can you explain much more please i can't understand Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted July 28, 2010 Author Moderators Report Share Posted July 28, 2010 do you mean phpmyadmin?and if you mean this where can i find it? Quote Link to comment Share on other sites More sharing options...
Jeff Posted July 28, 2010 Report Share Posted July 28, 2010 phpMyAdmin is found in your cPanel Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted July 28, 2010 Author Moderators Report Share Posted July 28, 2010 i know that but where can i find the highest pilotid +1? Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted July 28, 2010 Report Share Posted July 28, 2010 I have to caution you that if you do not know what you are doing you can really do some damage inside of phpAdmin. Since you don't know where to find phpAdmin I would say that your best bet is to just leave it alone. If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added. Quote Link to comment Share on other sites More sharing options...
dimitris Posted July 28, 2010 Report Share Posted July 28, 2010 I have to caution you that if you do not know what you are doing you can really do some damage inside of phpAdmin. Since you don't know where to find phpAdmin I would say that your best bet is to just leave it alone. If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added. Thank you lorathon !!! you save us ! servetas is my VCEO and his knowledge about web develop and phpmyadmin isn't good... It is ok now and working fine ! Thanks once again :rolleyes: p.s im the web manager 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.