Moderators joeri Posted October 25, 2009 Moderators Report Share Posted October 25, 2009 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 Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted October 25, 2009 Report Share Posted October 25, 2009 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. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted October 25, 2009 Administrators Report Share Posted October 25, 2009 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 Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted October 25, 2009 Author Moderators Report Share Posted October 25, 2009 ok will try it curently its sorted as new pilots first Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted October 26, 2009 Administrators Report Share Posted October 26, 2009 By hours is best? Quote Link to comment Share on other sites More sharing options...
faraz Posted December 14, 2009 Report Share Posted December 14, 2009 HI how can I sorting pilot page ? ;D Best Regard Quote Link to comment Share on other sites More sharing options...
infidel Posted December 14, 2009 Report Share Posted December 14, 2009 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. Quote Link to comment Share on other sites More sharing options...
faraz Posted December 14, 2009 Report Share Posted December 14, 2009 HI yes, Currently #1 is at the bottom. Not very user friendly. so Where can I change sorting ? Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted December 14, 2009 Author Moderators Report Share Posted December 14, 2009 in the pilotdata.class change this ORDER BY p.pilotid DEC"; to ORDER BY p.pilotid ASC"; hint look at line 85 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.