// show total value of the current cart function show_total_value() { $sql = sprintf("SELECT SUM(quantity * price) AS total FROM %s WHERE order_id = %d", ORDER_ROWS, $_SESSION['order_id']); if (!$result = mysql_query($sql)) { $this->error = $this->messages(1); return; } else { $total_amount = mysql_result($result, 0, "total"); mysql_free_result($result); return $total_amount; } }
Any help much appreciated,
Thanks, Chris Middleton
« Last Edit: May 03, 2007, 09:36:21 PM by chris_middleton »
Kill the googlebot
Posts: 6
48 credits Members referred : 0
« Reply #1 on: May 03, 2007, 09:46:52 PM »
having just gone back through my db's i realise its something i have missed out. Sorry for wasting your time!!
Chris
Moderator Community Supporter?
Jedai Sword Master
Gender:
Posts: 6440
39464 credits Members referred : 374