--- a/about.php +++ b/about.php @@ -1,25 +1,24 @@
-

Header-1

-
-orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit +

Header-1

+
+ orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit +
+

Header-2

+
+ orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit +
+

Header-3

+
+ orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit +
-

Header-2

-
-orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit -
-

Header-3

-
-orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit -
-
- @@ -35,29 +34,25 @@ FROM contractnotice WHERE "childCN" is null AND "parentCN" is null AND DATE("importDate") = (select * from (SELECT DATE("importDate") FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")'; $query = $conn->prepare($query); - $query->execute(); - if (!$query) { - databaseError($conn->errorInfo()); - } +$query->execute(); +databaseError($conn->errorInfo()); echo "
"; $stats = $query->fetch(PDO::FETCH_ASSOC); -echo $stats["count"] . " new records in period " . $stats["start"] . " to " . $stats["end"] ."
"; +echo $stats["count"] . " new records in period " . $stats["start"] . " to " . $stats["end"] . "
"; $query = 'SELECT DATE("importDate") as importday, count(*) as count, min("publishDate") as start, max("publishDate") as end FROM contractnotice WHERE ("childCN" is not null OR "parentCN" is not null) AND DATE("importDate") = (select * from (SELECT DATE("importDate") FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")'; $query = $conn->prepare($query); - $query->execute(); - if (!$query) { - databaseError($conn->errorInfo()); - } +$query->execute(); +databaseError($conn->errorInfo()); echo "
"; -$stats = $query->fetch(PDO::FETCH_ASSOC); -echo $stats["count"] . " updated records in period " . $stats["start"] . " to " . $stats["end"] ."
"; +$stats = $query->fetch(PDO::FETCH_ASSOC); +echo $stats["count"] . " updated records in period " . $stats["start"] . " to " . $stats["end"] . "
"; -echo "Last updated: ". $stats["importday"]."
"; +echo "Last updated: " . $stats["importday"] . "
"; /* Check for null Procurement method and 0 ABN when not ABN exempt */