| <?php | <?php |
| error_reporting(E_ALL); | error_reporting(E_ALL); |
| include_once("../lib/common.inc.php"); | include_once("../lib/common.inc.php"); |
| $unspscresult = mysql_query ("select * from UNSPSCcategories;"); | $unspscresult= $conn->prepare('select * from "UNSPSCcategories";'); |
| while ($row = mysql_fetch_assoc($unspscresult)) { | $unspscresult->execute(); |
| foreach ($unspscresult->fetchAll() as $row) { | |
| $unspsc[$row['UNSPSC']] = $row['Title']; | $unspsc[$row['UNSPSC']] = $row['Title']; |
| } | } |
| $catsresult = mysql_query ("SELECT LEFT( categoryUNSPSC, 2 ) as cat , SUM( value ) as value | $catsresult = $conn->prepare('SELECT substr( "categoryUNSPSC"::text, 0, 2 ) as cat , SUM( "value" ) as value |
| FROM `contractnotice` | FROM contractnotice |
| GROUP BY cat ;"); | GROUP BY cat ;'); |
| echo "<table>"; | echo "<table>"; |
| while ($row = mysql_fetch_assoc($catsresult)) { | $catsresult->execute(); |
| $catName = $unspsc[$row['cat']."000000"].$row['cat']; | foreach ($catsresult->fetchAll() as $row) { |
| $catName = $unspsc[$row['cat']."0000000"].$row['cat']; | |
| if ($row['cat'] == "") $catName = "null"; | if ($row['cat'] == "") $catName = "null"; |
| echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>"; | echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>"; |
| } | } |
| ?> | ?> |