--- a/displaySupplier.php +++ b/displaySupplier.php @@ -14,8 +14,15 @@ } include_header(str_replace("%", "", $title)); echo '

' . str_replace("%", "", $title) . '

'; +if ($supplierABN) { + $query = 'SELECT distinct on (lower("supplierName")) "supplierName" from contractnotice where "supplierABN" = :supplierABN'; + $query = $conn->prepare($query); + $query->bindParam(":supplierABN", $supplierABN); + $query->execute(); + databaseError($conn->errorInfo()); + echo "Also known as: ".implode(', ', $query->fetchAll(PDO::FETCH_COLUMN, 0)); +} /* - * Common names and uncommon names * Procurement method in text, seperate Open via SON from Open * Consultancies, Confidentialities percentage */