rpalmer800 Posted May 21, 2012 Report Share 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 Link to comment Share on other sites More sharing options...
flyalaska Posted May 21, 2012 Report Share 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 Link to comment Share on other sites More sharing options...
Administrators simpilot Posted May 21, 2012 Administrators Report Share 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 Link to comment Share on other sites More sharing options...
rpalmer800 Posted May 22, 2012 Author Report Share Posted May 22, 2012 OK, thanks to both. 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.