include_once ("./Includes/DBConn.php");



// Bar #1

	$query = "SELECT SUM(cogs) as totalcogs, SUM(sale_price) as totalsale_price, DATE_FORMAT(orderdate, '%Y') as totalyear FROM spec_registrar WHERE orderdate >= '2005' GROUP BY totalyear ";

	$link = connectToDB();



	$result = mysql_query($query);

	echo mysql_error($link);

	$num = mysql_numrows($result);



	$i = 0;

	$tot = 0;



	while ($i < $num) {

		$tot = $tot + mysql_result($result, $i, "totalsale_price");

		$i ++;

	}



	$xml = "
	$xml .= " showValues='0' numberPrefix = '$' formatNumberScale='0' showBorder='1' rotateYAxisName='1'> ";

	$i = 0;

	while ($i < $num) {

		$xml .= "";

		$i++;

	}

	$xml .= "";

	include("./Includes/FusionCharts.php");

	echo renderChartHTML("./FusionCharts/Column3D.swf", "", $xml, "Chart", 800, 500, false, true); 



?>