How to get the last order number in opencart?

Question

opencart

Hello!
How to get the last order number in opencart in category.tpl?
I tried this, but something doesn't work:
<?php
$orderLast = $this->db->query("SELECT * FROM `order` ". "ORDER BY `order`.`order_id` DESC LIMIT 1");
echo $orderLast;
?>

Answer 1

of course it will not work, the result must be processed before returning