How to get all rows from a database?

Question

opencart

There is an add-on for opencart that makes import / export of goods.
It has the ability to insert php that will be executed on processing each line.
Task: get any value from the database
There is this:

$products = $this->db->query("SELECT price FROM " . DB_PREFIX . "product_special");
$result = $products->row['price'];

Displays/gets only the first line. How to get everything? Running the output in a loop does not work, well, or I'm not doing it right In the $result

variable - the result of php execution should be displayed. The first column should have different values:

Answer 1

$products = $this->db->query("SELECT price FROM " . DB_PREFIX . "product_special");
foreach($products->rows as $raw){
         var_dump($raw['price']);
}