Сравнение чисел... :)

$query = 'select Name, cLevel, Restarts from Character order by Restarts desc';
$result = mssql_query( $query );
for($i=0;$i<mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
echo $i + 1;

В БД:
Name cLevel Restarts
Alisa 200 5
Vanja 210 5

$query = 'select Name, cLevel, Restarts from Character order by Restarts, cLevel desc';

$query = 'select Name, cLevel, Restarts from Character order by Restarts desc, cLevel desc';

$row = mssql_fetch_row($result);
echo $i + 1;

mysql> SELECT name, species, birth FROM pet ORDER BY species, birth DESC;

<?php
$input = array("red", "green", "blue", "yellow");
array_splice($input, 2);
// $input is now array("red", "green")

$input = array("red", "green", "blue", "yellow");
array_splice($input, 1, -1);
// $input is now array("red", "yellow")

$input = array("red", "green", "blue", "yellow");
array_splice($input, 1, count($input), "orange");
// $input is now array("red", "orange")

$input = array("red", "green", "blue", "yellow");
array_splice($input, -1, 1, array("black", "maroon"));
// $input is now array("red", "green",
// "blue", "black", "maroon")

$input = array("red", "green", "blue", "yellow");
array_splice($input, 3, 0, "purple");
// $input is now array("red", "green",
// "blue", "purple", "yellow");
?>

for($i=0;$i<mssql_num_rows($result);++$i)
вместо mssql_num_rows($result) надо было просто поставить 5 :P