Data update
[contractdashboard.git] / sitemap.xml.php
blob:a/sitemap.xml.php -> blob:b/sitemap.xml.php
--- a/sitemap.xml.php
+++ b/sitemap.xml.php
@@ -44,7 +44,7 @@
     }
     if ($_REQUEST['section'] == "supplier") {
        $result = $conn->query('SELECT DISTINCT on ("supplierID") (
- case when "supplierABN" != 0 THEN "supplierABN"::text ELSE "supplierName" END) as "supplierID", "supplierABN", "supplierName"  from contractnotice');
+ case when "supplierABN" != 0 THEN "supplierABN"::text ELSE lower("supplierName") END) as "supplierID", "supplierABN", "supplierName"  from contractnotice');
        
        foreach ($result->fetchAll() as $row) {