Question

<?

$ret=$DB->Query("SELECT adult_doc FROM city WHERE id=15", true);
print_r ($ret);

?>


Почему мне возвращается массив вместо числа 42(((.
Если ввести SELECT adult_doc FROM city WHERE id=15 в админке в SQl запрос выводит все правильно.А на самой странице выводит :
CDBResult Object ( [result] => Resource id #50 [arResult] => [bNavStart] => [bShowAll] => [NavNum] => [NavPageCount] => [NavPageNomer] => [NavPageSize] => [NavShowAll] => [NavRecordCount] => [bFirstPrintNav] => 1 [PAGEN] => [SIZEN] => [add_anchor] => [bPostNavigation] => [bFromArray] => [bFromLimited] => [sSessInitAdd] => [nPageWindow] => 11 [nSelectedCount] => [arGetNextCache] => [bDescPageNumbering] => [arUserMultyFields] => [SqlTraceIndex] => [DB] => CDatabase Object ( [DBName] => bitrix [DBHost] => localhost [DBLogin] => root [DBPassword] => [bConnected] => 1 [version] => [cntQuery] => 0 [timeQuery] => 0 [column_cache] => Array ( ) [obSlave] => [db_Conn] => Resource id #7 [debug] => [DebugToFile] => [ShowSqlStat] => [db_Error] => [result] => [type] => MYSQL [arQueryDebug] => Array ( ) [bModuleConnection] => [bNodeConnection] => [bMasterOnly] => ) )

Answer 1

Потомучто возвращаеться обект

http://dev.1c-bitrix.ru/api_help/main/reference/cdbresult/index.php

Answer 2

$DB->Query возвращает объект, чтобы получить значения adult_doc нужно еще

Код
while ($ar = $ret->Fetch()) { print_r($ar['adult_doc']); }

Answer 3

Спасибо большое :)