--- a/heuristics/viewHeuristicsDistribution.php
+++ b/heuristics/viewHeuristicsDistribution.php
@@ -6,7 +6,7 @@
 
 // spread of values
 select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) 
-as sum FROM heuristic_results group by CNID) as a group by val*/
+as sum FROM heuristic_results group by "CNID") as a group by val*/
 
 $series = Array();
 
@@ -17,4 +17,17 @@
     $series[$r["heuristic_name"]][$r["val"]] = $r[2];
 }
 
+ $labels = Array();
+ foreach ($series as $value) {
+    $labels = $labels+array_keys($value);
+ }
+ $labels =  Array(0,1,2,3,4,5);
+foreach ($series as $seriesName => $seriesEntry) {
+    $data;
+ foreach ($labels as $label) {
+    $data[$label] = ($seriesEntry[$label] ? $seriesEntry[$label] : 0);
+ }
+}
+print_r($labels);
+print_r($data);
 ?>