--- 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) {