https://www.icyphoenix.com/viewtopic.php?f=26&t=2698&p=19067#p19067
-----------------------------------
Mighty Gorgon
Wed 29 Aug, 2007 00:41

Re: Question About Multiple Ranks And Staff View V2.0.3
-----------------------------------
You can try something similar to this...

OPEN [b]ranks.php[/b]
FIND
[codeblock]$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_min ASC";[/codeblock]
REPLACE WITH
[codeblock]$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_title ASC, rank_min ASC";[/codeblock]

This will sort by rank type and then alphabetically.