--- a/admin/displayUNSPSC.php
+++ b/admin/displayUNSPSC.php
@@ -3,16 +3,19 @@
   include_once("../lib/common.inc.php");
 
 
-$unspscresult = mysql_query ("select * from UNSPSCcategories;");
-while ($row = mysql_fetch_assoc($unspscresult)) {
+$unspscresult= $conn->prepare('select * from "UNSPSCcategories";');
+$unspscresult->execute();
+foreach ($unspscresult->fetchAll() as $row) {
 	$unspsc[$row['UNSPSC']] = $row['Title'];
+
 }
-$catsresult = mysql_query ("SELECT LEFT( categoryUNSPSC, 2 ) as cat , SUM( value ) as value
-FROM `contractnotice`
-GROUP BY cat ;");
+$catsresult = $conn->prepare('SELECT substr( "categoryUNSPSC"::text, 0, 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'];
+$catsresult->execute();
+foreach ($catsresult->fetchAll() as $row) {
+	$catName = $unspsc[$row['cat']."0000000"].$row['cat'];
 	if ($row['cat'] == "") $catName = "null";
 	
 	echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>";