<?php
error_reporting(E_ALL);
 
$link = mysql_connect('localhost', 'team7', 'wlUsnD2xu9');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
@mysql_select_db("team7") or die("Unable to select database");
 
$unspscresult = mysql_query ("select * from UNSPSCcategories;");
while ($row = mysql_fetch_assoc($unspscresult)) {
        $unspsc[$row['UNSPSC']] = $row['Title'];
}
$catsresult = mysql_query ("SELECT LEFT( categoryUNSPSC, 2 ) as cat , SUM( value ) as value
FROM `contractnotice`
GROUP BY cat ;");
echo "<table>";
while ($row = mysql_fetch_assoc($catsresult)) {
        $catName = $unspsc[$row['cat']."000000"].$row['cat'];
        if ($row['cat'] = "") $catName = "null";
        
        echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>";
}
?>