CLAnswer::GetList

static function GetList($arOrder=Array(), $arFilter=Array())
{
	global $DB, $USER;

	$arSqlSearch = CLAnswer::GetFilter($arFilter);

	$strSqlSearch = "";
	for($i=0; $i '')
			$strSqlSearch .= " AND ".$arSqlSearch[$i]." ";

	$strSql =
	"SELECT CA.*, CQ.ID AS QUESTION_ID, CQ.NAME AS QUESTION_NAME ".
	"FROM b_learn_answer CA ".
	"INNER JOIN b_learn_question CQ ON CA.QUESTION_ID = CQ.ID ".
	"WHERE 1=1 ".
	$strSqlSearch;

	if (!is_array($arOrder))
		$arOrder = Array();

	$arSqlOrder = [];
	foreach($arOrder as $by=>$order)
	{
		$by = mb_strtolower($by);
		$order = mb_strtolower($order);
		if ($order!="asc")
			$order = "desc";

		if ($by == "id") $arSqlOrder[] = " CA.ID ".$order." ";
		elseif ($by == "sort") $arSqlOrder[] = " CA.SORT ".$order." ";
		elseif ($by == "correct") $arSqlOrder[] = " CA.CORRECT ".$order." ";
		elseif ($by == "answer") $arSqlOrder[] = " CA.ANSWER ".$order." ";
		elseif ($by == "rand") $arSqlOrder[] = CTest::GetRandFunction();
		else
		{
			$arSqlOrder[] = " CA.ID ".$order." ";
			$by = "id";
		}
	}

	$strSqlOrder = "";
	DelDuplicateSort($arSqlOrder);
	for ($i=0; $iQuery($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}