--- a/displaySupplier.php +++ b/displaySupplier.php @@ -55,27 +55,31 @@ histograph of supplier size/value */ include_header("Suppliers"); - $query = "SELECT SUM(value) as val, supplierName, supplierABN + $query = "SELECT SUM(value) as val, supplierName, supplierABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID FROM `contractnotice` WHERE childCN = 0 -GROUP BY supplierName +GROUP BY supplierID ORDER BY val DESC LIMIT 100"; $result = mysql_query($query); echo "
Position | Supplier | Total Contract Value |
---|---|---|
".ucsmart($row['supplierName'])." | \$$value | |
$i | ".ucsmart($row['supplierName'])." | \$$value |