Daniel Posted November 24, 2010 Report Share Posted November 24, 2010 Ok i chnages someone's pilot id to 029 and then i wanted them in order. so i changed everyone's pilot id in order so now they go to 013. When someone registered there pilot id was 30. I know i probally have to do something in the database but what? where? thank you in advance. http://pashairvirtual.co.uk Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted November 24, 2010 Moderators Report Share Posted November 24, 2010 It's the database which it is automatically creating new id's by id's. I'm not sure if you can fix this, but if you alter the db, with same pilot ID, it will go crazy and casue a mess. So you will have to manuly re enter the Id's Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted November 24, 2010 Moderators Report Share Posted November 24, 2010 Yes you can manually reset the ID's as you have mentioned then go to phpmyadmin and your pilots table then click on the operations tab at the top and run "Optimize table" That will reset the next id for you.I wouldn't normally recommend messing about like that on a love site as all bad stuff can happen. Quote Link to comment Share on other sites More sharing options...
Daniel Posted November 25, 2010 Author Report Share Posted November 25, 2010 ok thanks mark 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.