--- a/graphs/displayContractPublishedGraph.php
+++ b/graphs/displayContractPublishedGraph.php
@@ -1,7 +1,7 @@
 <?php

 include_once("../lib/common.inc.php");

 $query = "SELECT YEAR(publishDate), MONTH(publishDate),

-value, count(1) as count FROM `contractnotice`

+SUM(value) as val, count(1) as count FROM `contractnotice`

 WHERE (YEAR(publishDate) >= 2008)

 AND childCN = 0

 GROUP BY MONTH(publishDate), YEAR(publishDate) 

@@ -12,11 +12,11 @@
 $values = Array();

 while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

 setlocale(LC_MONETARY, 'en_US');

-$value = number_format(doubleval($row["value"]),2);

+$value = number_format(doubleval($row["val"]),2);

 $month_name = date( 'F', mktime(0, 0, 0, $row[1]) );

 	$dates[] = $month_name." {$row[0]}";

 	$counts[] = doubleval($row["count"]);

-	$values[] = doubleval($row["value"]);

+	$values[] = doubleval($row["val"]);

 }

 mysql_free_result($result);

 

@@ -31,7 +31,7 @@
 $graph->SetScale('textlog');

  

 // Setup a title for the graph

-$graph->title->Set('Contracts Starting - All Agencies since July 2008');

+$graph->title->Set('Contracts Published - All Agencies since July 2008');

 $graph->SetUserFont("liberation/LiberationSans-Regular.ttf");

 $graph->title->SetFont(FF_USERFONT,FS_NORMAL,12);