Recent Pilots and SQL

[UAL3626]

Hello folks,

I'm curious if there is anyone able to help me out with a few issues I am having when a pilot registers? When a new pilot registers on my site it automatically assigns their new ID, however in the application I have a custom field allowing each pilot to chose a custom ID. Once I have accepted their app they appear under the recent pilots section but when I modify their callsign according to their requested ID they disappear.

I have done a bit of research and have found out that the SQL database is showing these new pilots in an automatic order (ascending) possibly through the pilotid only. If their ID is not next in line like below they do not appear. How do I fix this?

For example the last 5 pilots will apear as the following but anyone who selects a callsign such as UAL2314 will not appear.

UAL3630

UAL3629

UAL3628

UAL3627

UAL3626

I have created a new column called "order" in the SQL DB to see if I can show each pilot regardless of their actual number instead of it showing the newest members based on "pilotid" (ascending order). I have tinkered with is and tried to remove the keys and reassign them and even tried to remove and reassign the autoincrement but nothing works. I am by far no expert in SQL but am a quick learner and have limited knowledge. Any advice on this table structure would be greatly appreciated. From what I have found modifying this table too much especially the "pilotid" with the keys could cause problems with my limited knowledge.

The site is www.virtualunitedair.com in case anyone needs it.

PLEASE DELETE. I'M SORRY FOR THE INCONVENIENCE. THIS IS MY FIRST DAY OFF AND I FOUND A TOPIC THAT WAS POSTED WHILE I WAS AT WORK A FEW DAYS AGO.

Edited April 2, 2011 by UAL3626