pilot page sorting

[joeri]

how can i sort the table so that the pilot with most hours or most flights is on top.i have been trying different stuff but can't get it to work.

and is there a way to only show the active pilots in the pilots list or an icon that says inactive or active

[TAV1702]

and is there a way to only show the active pilots in the pilots list or an icon that says inactive or active

That would be great. I have been thinking about 2 different pages. 1 for active like we have now, and if they click a link, it will show only inactive. Not sure if that is doable though.

[Nabeel]

You can check the $pilot->active field, or the $pilot->retired. Try print_r($pilot) to see the fields.

How is it sorted now? I don't remember

[joeri]

ok will try it

curently its sorted as new pilots first

[Nabeel]

By hours is best?

[faraz]

HI

how can I sorting pilot page ?  ;D

Best Regard

[infidel]

I personally would prefer for the pilots to be in descending numerical order so 1st pilot registered is on top. Currently #1 is at the bottom. Not very user friendly.

[faraz]

HI

yes, Currently #1 is at the bottom. Not very user friendly. so Where can I change sorting ?

[joeri]

in the pilotdata.class change this

ORDER BY p.pilotid DEC";

to

ORDER BY p.pilotid ASC";

hint look at line 85