--- a/heuristics/runHeuristics.php +++ b/heuristics/runHeuristics.php @@ -7,7 +7,7 @@ FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName WHERE DATE(importDate) = (select * from (SELECT DATE(importDate) FROM contractnotice ORDER BY importDate DESC limit 1) alias)"; -$result = mysql_query($lastimportquery); +$result = mysql_query($query); if (!$result) echo mysql_error().$query; while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) { //get each new CN from latest update