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
WHERE
(CubeCart_order_inv.name LIKE 'Ghost Hunt -%')
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']. " = $". round($row_tickets_sold['tickets_total'],2) . " Tickets Sold = "($row_tickets_sold['tickets_total'],2) / 51.75 ;
echo "<br />";
}
;?>