More MySQL purging
[contractdashboard.git] / heuristics / metadataHeuristics.php
blob:a/heuristics/metadataHeuristics.php -> blob:b/heuristics/metadataHeuristics.php
--- a/heuristics/metadataHeuristics.php
+++ b/heuristics/metadataHeuristics.php
@@ -14,8 +14,8 @@
 	$averageDuplicatedDescriptions = getAverageDuplicatedDescriptions();
 	$stddevDuplicatedDescriptions = getstddevDuplicatedDescriptions();
 	$query = 'select count(*) from contractnotice where description = "' . $agencyName . '"';
-	$result = mysql_query($query);
-	$r = mysql_fetch_array($result, MYSQL_BOTH);
+    $result = $conn->query($query);
+    $r = $result->fetch(PDO::FETCH_BOTH);
 	$dupeDesc = $r[0];
         if ($dupeDesc == 1) $value = 0;
 	else $value = abs($dupeDesc - $averageDuplicatedDescriptions) / $stddevDuplicatedDescriptions;
@@ -51,8 +51,8 @@
 FROM `contractnotice` 
 group by description having count > 1 
         ) as a;";
-	$result = mysql_query($query);
-	$r = mysql_fetch_array($result, MYSQL_BOTH);
+    $result = $conn->query($query);
+    $r = $result->fetch(PDO::FETCH_BOTH);
 	$averageDuplicatedDescriptions = $r[0];
 	$stddevDuplicatedDescriptions = $r[1];
 }