CUser::GetDropDownList

static function GetDropDownList($strSqlSearch="and ACTIVE='Y'", $strSqlOrder="ORDER BY ID, NAME, LAST_NAME")
{
	global $DB;
	$err_mess = (CUser::err_mess())."
Function: GetDropDownList
Line: ";
	$strSql = "
		SELECT
			ID as REFERENCE_ID,
			concat('[',ID,'] (',LOGIN,') ',ifnull(NAME,''),' ',ifnull(LAST_NAME,'')) as REFERENCE
		FROM
			b_user
		WHERE
			1=1
		$strSqlSearch
		$strSqlOrder
		";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $res;
}