Sorting results, first one fixed then alaphabetized?

[horstuff]

I'm pulling results from the db and printing them as a list. Does anybody know how I could sort results and have the first couple fixed, then all the rest after that alphabetized? For instance, I need my first result to say "Freds One Year Warranty", the second to say "Freds Ywo Year Warranty", then all the rest after that alphabetized, like "Ajax One Year", Cals One Year", etc. Thanks.

Here is my code (warranty_comment is the field I need to sort by)

$query="SELECT aw_id,warranty_comment FROM warranty ORDER BY warranty_comment ASC";
$result=mysql_query($query);
while (list($aw_id,$warranty_comment)= mysql_fetch_row($result)){

 print "<a href=\"javascript<img src="images/smilies/redface.gif" border="0" alt="">penWindow('window.php?action=viewwarranty2&view=$aw_id')\">$warranty_comment</a><br>";
}

[mmilano]

doesn't make sense. what are the first 'two fixed' results determined by?

[horstuff]

exactly the point of my question. The only way I can figure to do this is to have two seperate queries, one for the first results and another for the second, but I was wondering if there was a better way, and if not, how would I write the two queries?