Why does the fetch method return only one element in bitrix?

Question

1C-Bitrix

$s = $DB->Query("
      SELECT
        QUANTITY
      FROM
        b_catalog_product 
      ");
dd($s->fetch());

How to remove all elements from the database? fetchAll doesn't work.

Answer 1

Cycle through and collect.

while ($row = $results->Fetch())
{
echo $row['NAME'];//выводим все значения, которые вернул запрос
}

Well, read the doc https://dev.1c-bitrix.ru/api_help/main/reference/c...