rpalmer800 Posted May 21, 2012 Report Posted May 21, 2012 SOLVED Hey, So i understand that once you change a pilots ID the new pilots are going to start at that number, but is there anyway to make it go back to continue the order, because i just went through and fixed all of our ID's so it goes in number order... Thanks, Any help would be greatly appreciated. http://vdalairlines....ndex.php/Pilots Quote
flyalaska Posted May 21, 2012 Report Posted May 21, 2012 That is not 100% true. My ID numbers are in the 600's. I changed someone to 138 and we are still in order. I think you can change the next number in order in the sql. Thats how I did it in FSACARS. Not 100% sure on phpVMS. Quote
Administrators simpilot Posted May 21, 2012 Administrators Report Posted May 21, 2012 Use phpmyadmin and goto the _pilots table and click on the operations tab. Set the auto increment value to the highest id in the database plus one. Quote
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.