--- a/about.php +++ b/about.php @@ -1,61 +1,61 @@ - - -
-

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 -
-
- - -sourced from austender - -Government Agency Information (2009-07-10): National Archives of Australia, http://www.naa.gov.au under Creative Commons - Attribution 2.5 Australia (CC-BY) - -ABR - -prepare($query); -$query->execute(); -databaseError($conn->errorInfo()); -echo "
"; -$stats = $query->fetch(PDO::FETCH_ASSOC); -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(); -databaseError($conn->errorInfo()); -echo "
"; -$stats = $query->fetch(PDO::FETCH_ASSOC); -echo $stats["count"] . " updated records in period " . $stats["start"] . " to " . $stats["end"] . "
"; - - -echo "Last updated: " . $stats["importday"] . "
"; -/* Check for null Procurement method and 0 ABN when not ABN exempt */ - - -include_footer(); -?> + +
+

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 +
+
+ + +sourced from austender + +Government Agency Information (2009-07-10): National Archives of Australia, http://www.naa.gov.au under Creative Commons - Attribution 2.5 Australia (CC-BY) + +ABR + +prepare($query); +$query->execute(); +databaseError($conn->errorInfo()); +echo "
"; +$stats = $query->fetch(PDO::FETCH_ASSOC); +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(); +databaseError($conn->errorInfo()); +echo "
"; +$stats = $query->fetch(PDO::FETCH_ASSOC); +echo $stats["count"] . " updated records in period " . $stats["start"] . " to " . $stats["end"] . "
"; + + +echo "Last updated: " . $stats["importday"] . "
"; +/* Check for null Procurement method and 0 ABN when not ABN exempt */ + + +include_footer(); +?> +