--- 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(); ?> +