Total Amount on Checkout Success?

[xIllu]

hi,

 

how can I get the total amount of the items on the checkout_sucess.php ?

i need that for the affilate program so it can calculate the % they get from the total amount ordered..

 

tnx

[xIllu]

i have to /bump this since i still dont know the answer :/

[boxtel]

i have to /bump this since i still dont know the answer :/

 

I use this :

 

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1");

$orders = tep_db_fetch_array($orders_query);

 

echo TEXT_YOUR_ORDER_NUMBER . $orders['orders_id'] . '<br><br>';

 

$order_total_query = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where class = 'ot_total' and orders_id = '" . $orders['orders_id'] . "'");

 

$order_total_result = tep_db_fetch_array($order_total_query);

 

echo 'Total Order Value: ' . $order_total_result['text'] . '<br><br>';