--- a/heuristics/viewHeuristicsColormap.php
+++ b/heuristics/viewHeuristicsColormap.php
@@ -41,17 +41,16 @@
 }
 $Gradients = Gradient("66FF00" , "FF0000" , 10); 
   
-$query = "select max(sum) from (SELECT sum(heuristic_value) 
-as sum FROM heuristic_results group by CNID) as a";
-$result = mysql_query($query);
-$r = mysql_fetch_array($result, MYSQL_BOTH);
+$query = 'select max(sum) from (SELECT sum(heuristic_value) 
+as sum FROM heuristic_results group by "CNID") as a';
+    $result = $conn->query($query);
+    $r = $result->fetch();
 $maxVal = $r[0];
   
-$query = "SELECT sum(heuristic_value) as sum, CNID
-FROM `heuristic_results` group by CNID order by sum DESC LIMIT 300";
-$result = mysql_query($query);
-if (!$result) echo mysql_error().$query;
-while ($r = mysql_fetch_array($result, MYSQL_BOTH)) {
+$query = 'SELECT sum(heuristic_value) as sum, "CNID"
+FROM heuristic_results group by "CNID" order by sum DESC LIMIT 300';
+    $result = $conn->query($query);
+foreach ($result->fetchAll() as $r) {
     echo '<div style="background: #'.$Gradients[floor(($r['sum']/$maxVal) * 10)].';">';
     echo '<a title="'.$r['sum'].'" href="../displayContract.php?CNID='.$r['CNID'].'">X</a>';
     echo "</div>";