Can I order a DB search by two factors?

[refiking]

I am running a script that checks returns the records in a table by the rank descending down.  But, when there are 2 people with the same rank, how can I get it to show me the first record with that rank?  Here is the snippet:

 

<?
include 'cont.php';
$result = mysql_query("SELECT tag FROM recruits ORDER BY rank DESC");
while($row = mysql_fetch_array($result))
  {
  $tag = $row['tag'];
?><font color="silver">
<strong><?echo $tag."<br>";}?></strong></font>
</td></table>
</body>

[cooldude832]

I let you make that decision

http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

[Barand]

how can I get it to show me the first record with that rank? 

 

Define "first"

[refiking]

What I mean by first is the first record that was actually inserted into the table.  For example, if Bill inserted a record on Monday and Rex inserted a record on Wednesday and both have a rank of 250, how can I get it to show Bill before Rex?

 

[marun]

Add date filed to the database and sort result by date.