Virtual Villagers: The Lost Children Leaderboard " . $OrderBy . "";
$sql = "select * from " . $score_table . " " . $sqlwhere . $sqlorderby;
// query the database
// $sql = "select * from $score_table order by deaths desc";
if (!$db->sql_query($sql))
{
messageDie(ERR_DATABASE, $sql, $db);
}
echo "";
echo "
Sorted by Number of Village Elders ";
echo "";
echo "
";
// loop through result and display
while($i < $numDisplayed && $score = $db->sql_fetchrow())
{
$i++;
echo "
" . $i . "
" . $score["player_name"] . "
" . $score["babies_made"] . "
" . $score["hours_played"] . "
" . $score["techpoints_earned"] . "
" . $score["deaths"] . "
" . $score["twins_birthed"] . "
" . $score["number_events"] . "
";
}
echo "
";
?>
1NOTE:Bullets (•) indicate a tie. For
example: If four people all have 53 elders, their ranks are all 1 and are
shown as 1, •, •, •. The fifth person holds rank
5.
