--- 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]; }