Data output order

[EchoFool]

Hey need some help guys and gals.

 

Just wondering how do i while loop data in order of word rankings.. for example... say "Leader" becomes before "Co-Leader".

 

I have the rankings in the field rank. But i was unsure how to make it a list of words.

 

This is what i put in my Select:

 

<?php
$Get = mysql_query("SELECT UserID,Rank FROM gangmembers WHERE GangID='$GangID' ORDER BY Rank='Leader',Rank='Co-Leader'")
Or die(mysql_error());
While($row = mysql_fetch_assoc($Get)){
$Rank = $row['Rank'];
$UserID = $row['UserID'];
?>
<tr>
<td width="200" align="center" class="blackBold"><?php echo $UserID;?></td>
<td width="200" align="center" class="blackBold"><?php echo$Rank;?></td>
<td width="200" align="center" class="blackBold"><a href="ganghq.php?team&fire=<?=$RecordID?>">Fire</a></td>
</tr>
<?php
	}
}
?>

 

Sadly it does not work though . Any suggestions?

[DarkWater]

Ranks are often stored numerically so you can order them properly, not as strings. >_<

[waynew]

Yep. Use numeric values. That way you can order them. Maybe keep a config array file somewhere to keep track of what is what.