Read Order Total from a module.

[JustAnotherMe]

I need to read the actual order Total with tax. I could do an sql approach but i cant find an erm of the database ... can any one help me pls

[JustAnotherMe]

global $cookie;
$sql = 'SELECT total_products_wt
          FROM '._DB_PREFIX_.'orders                                     
           WHERE id_customer = "'.$cookie->id_customer.'"
           ORDER BY date_add DESC 
           LIMIT 1';

$amount = Db::getInstance()->getValue($sql);

thats the code i got so far (not working), my sql is correct so i got some of the presta stuff wrong ...

[tomerg3]

You mean the total of the items that are currently in the cart?

[JustAnotherMe]

yes ( i only need to read it after the order is finished )

ps : iam still seeking for a build in functionality

[tomerg3]

When the order is finished, the cart is empty.

a database query is NOT the way to do it, but I need to know if which page you are trying to get this info, so I can tell you how to get the order object, which can then easily retrieve the order total.