Add currency sorting
[contractdashboard.git] / displaySupplier.php
blob:a/displaySupplier.php -> blob:b/displaySupplier.php
--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -58,7 +58,7 @@
   $query = "SELECT SUM(value) as val, supplierName, supplierABN
 FROM `contractnotice`
 WHERE childCN = 0
-GROUP BY supplierName
+GROUP BY supplierABN
 ORDER BY val DESC
 LIMIT 100";
   $result = mysql_query($query);
@@ -79,3 +79,4 @@
 }
 include_footer();
 ?>
+