Q>About castle on FluxCP

[ShogS]

<?php

if (!defined('FLUX_ROOT')) exit;

$title = 'Castles';

$sql = "SELECT castles.castle_id, castles.guild_id, guild.name AS guild_name, guild.emblem_len FROM {$server->charMapDatabase}.guild_castle AS castles ";

$sql .= "LEFT JOIN guild ON guild.guild_id = castles.guild_id ORDER BY castles.castle_id ASC";

$sth = $server->connection->getStatement($sql);

$sth->execute();

$castles = $sth->fetchAll();

$castleNames = Flux::config('CastleNames')->toArray();

?>

HOW can I put some Limits uppon showing the records of the castle owned. I would to show just 5 castle records on every page. How can I implement this? Like sa GUILD Rank 20 limits?

Help Please.

[Emistry]

http://fluxcp.googlecode.com/svn/branches/fluxcp-1.0/config/application.php.

'ResultsPerPage'	   => 20,					   // The number of results to display in a paged set, per page.
...
....
....

'GuildRankingLimit'   => 20,                        //

[ShogS]

http://fluxcp.google...application.php.

'ResultsPerPage'	   => 20,					   // The number of results to display in a paged set, per page.
...
....
....

'GuildRankingLimit'   => 20,						//

Done resolving it tnx to

jupeto