In old acc. maker:
PHP:
$players_from_logged_acc->orderBy('name');
In 2012 it must be:
PHP:
$players_from_logged_acc->addOrder(new SQL_Order('name', SQL_Order::ASC));
or (
ASCending order is default, so you don't have to pass second parameter, but you can also use
DESCending order):
PHP:
$players_from_logged_acc->addOrder(new SQL_Order('name'));
EDIT:
In new acc. maker you can add more then one order. Example (show top 5 players [level]):
PHP:
$topPlayers = new DatabaseList('Player');
$topPlayers->addOrder(new SQL_Order('level', SQL_Order::DESC));
$topPlayers->addOrder(new SQL_Order('experience', SQL_Order::DESC));
$topPlayers->setLimit(5);
foreach($topPlayers as $player)
{
echo $player->getName() . ' - ' . $player->getLevel() . ' lvl<br />';
}
It shows top 5 players in level. It first sort by 'level' [it's first in PHP, it's more impotant] and then by 'experience'. If few players have same level, player with higher amount of exp will be higher on list. It's DESCending order, so it shows 5 players with highest levels, ASCending order would show 5 players with lowest levels.