--- 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>"; }