Add bubbletree
[contractdashboard.git] / admin / displayUNSPSC.php
blob:a/admin/displayUNSPSC.php -> blob:b/admin/displayUNSPSC.php
--- a/admin/displayUNSPSC.php
+++ b/admin/displayUNSPSC.php
@@ -1,11 +1,7 @@
 <?php

 error_reporting(E_ALL);

+  include_once("../lib/common.inc.php");

 

-$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)) {

@@ -17,7 +13,7 @@
 echo "<table>";

 while ($row = mysql_fetch_assoc($catsresult)) {

 	$catName = $unspsc[$row['cat']."000000"].$row['cat'];

-	if ($row['cat'] = "") $catName = "null";

+	if ($row['cat'] == "") $catName = "null";

 	

 	echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>";

 }