rendered paste body<?php
require_once('../../Connections/ghostlicense.php');
require_once('../../Connections/Shopping.php');
mysql_select_db($database_Shopping, $Shopping);
$query_tickets_sold = "
SELECT
CubeCart_order_inv.name,
SUM(CubeCart_order_sum.prod_total) as tickets_total
FROM
CubeCart_order_sum,
CubeCart_order_inv
GROUP BY CubeCart_order_inv.name";
$tickets_sold = mysql_query($query_tickets_sold, $Shopping) or die(mysql_error());
while ($row_tickets_sold = mysql_fetch_array($tickets_sold)){
echo $row_tickets_sold['name']. " = $". $row_tickets_sold['SUM(tickets_total)'];
echo "<br />";
}
;?>