Pilot Id's [Solved]

[Daniel]

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

[Kyle]

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

[mark1million]

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.

[Daniel]

ok thanks mark