function getOrdinal($number)
{
// find the last digit of the number using the modulo
$lastDigit = $number % 10;
// find the last two numbers
$n = round(($number / 100 - floor($number / 100)) * 100);
switch (true) {
case $lastDigit == 1 && $n != 11:
$ordinal = 'st';
break;
case $lastDigit == 2 && $n != 12:
$ordinal = 'nd';
break;
case $lastDigit == 3 && $n != 13:
$ordinal = 'rd';
break;
default:
$ordinal = 'th';
break;
}
return $ordinal;
}
// getOrdinal
for ($c = 0; $c < 301; $c++) {
echo '<span>The number and ordinal is ' . $c . getOrdinal($c) . '.</span><br />';
}
// for $number
?>
</body>
</html>
// retrieve player's best ranking
//
$bestPlayerScore = (int) $scorePlayers[0];
if ($bestPlayerScore > 0) {
// retrieve number of positions above player
$qryRanking = 'SELECT
COUNT(*) AS rank
FROM
scores AS s
WHERE
s.score > \'' . (int) $bestPlayerScore . '\'';
$resRanking = mysql_query($qryRanking);
$row = mysql_fetch_assoc($resRanking);
// add one because we want it in terms of 1st, 2nd etc.
$playerBestRank = $row['rank'] + 1;
$playerBestRank .= getOrdinal($playerBestRank);
} else {
$playerBestRank = 'n/a';
}
//
// retrieve player and world's average score
//
$qryPlayerAvg = 'SELECT
AVG(score) AS score
FROM
scores
WHERE
player_id = \'' . (int) $playerID . '\'';
$resPlayerAvg = mysql_query($qryPlayerAvg);
$avgPlayer = round(mysql_result($resPlayerAvg, 0));
$qryWorldAvg = 'SELECT
