The method GetList returns a filtered and sorted list of topics.
Parameters
Parameter
Description
arOrder
An array of the format Array(by1=>order1[, by2=>order2 [, ..]]), where:
by - the field by which the list is to be sorted. The following values are possible:
ID - the topic ID;
TITLE - the topic title;
STATE - topic state;
USER_START_ID - the ID of the user who has created a
topic;
USER_START_NAME - the name of the user who has created a topic;
START_DATE - the date the topic was created;
POSTS - number of posts in the topic;
VIEWS - number of topic views;
APPROVED - the topic is approved and published.
LAST_POST_DATE - the date the last message was created in
the topic;
SORT - sort index;
order - sort order. The following values are possible:
ASC - ascending;
DESC - descending;
Optional. The default value is Array("SORT"=>"ASC")
arFilter
An array of the format array("filter field"=>"filter value" [, ...]).
The "filter field" can be one of the following:
STATE - topic state;
FORUM_ID - the forum ID;
ID - the topic ID;
APPROVED - the topic is approved and published;
LAST_POST_DATE - the date the last message was created in the
topic;
The filtered field may contain one of the following condition operators before the name:
"!" - not equal;
"<" - less than;
"<=" - less or equal;
">" - more than;
">=" - more or equal.
Optional. By default, records are not filtered.
bCount
If parameter is true, only the number of topics that conforms to the
specified filter is returned.
Optional. The default value is false.
iNum
Maximum number of records returned. If the parameter iNum is not zero, a
maximum of iNum records is returned. Not all databases support this
feature. If the feature is not supported, this parameter is ignored.
Optional. The default value is 0.
<?
// Select all the published topics of the forum $FID,
// that were sorted first by sort index,
// then by the date of the last message in the topic
$db_res = CForumTopic::GetList(array("SORT"=>"ASC",
"LAST_POST_DATE"=>"DESC"),
array("FORUM_ID"=>$FID));
while ($ar_res = $db_res->Fetch())
{
echo $ar_res["TITLE"]."<br>";
}
?>