--- a/displaySupplier.php +++ b/displaySupplier.php @@ -55,24 +55,27 @@ 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 supplierABN +GROUP BY supplierID ORDER BY val DESC LIMIT 100"; $result = mysql_query($query); echo "<table> <thead> <tr> + <th>Position</th> <th>Supplier</th> <th>Total Contract Value</th> </tr> </thead>"; +$i = 1; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { setlocale(LC_MONETARY, 'en_US'); $value = number_format(doubleval($row['val']) , 2); $supplier = stripslashes($row['supplierABN'].'-'.$row['supplierName']); - echo ("<tr><td><b><a href=\"displaySupplier.php?supplier={$supplier}\">".ucsmart($row['supplierName'])."</a></b></td><td>\$$value</td></tr>\n"); + echo ("<tr><td>$i</td><td><b><a href=\"displaySupplier.php?supplier={$supplier}\">".ucsmart($row['supplierName'])."</a></b></td><td>\$$value</td></tr>\n"); + $i++; } echo "</table>"; mysql_free_result($result);