--- a/admin/updateUNSPSC.php +++ b/admin/updateUNSPSC.php @@ -7,9 +7,10 @@ $unspscresult = $conn->prepare('select * from "UNSPSCcategories";'); $unspscresult->execute(); foreach ($unspscresult->fetchAll() as $row) { + $row['Title'] = strtolower($row['Title']); $unspsc[strtolower($row['Title'])] = $row['UNSPSC']; // some Australian spellings -/* $isiz = str_replace("iz", "is", $row['Title']); + $isiz = str_replace("iz", "is", $row['Title']); $unspsc[$isiz] = $row['UNSPSC']; $filfill = str_replace("fill", "fil", $row['Title']); $unspsc[$filfill] = $row['UNSPSC']; @@ -50,7 +51,7 @@ // some just plain wrong $noOilRigs = str_replace("Building and Construction and Maintenance Services", "Management and provision of all facilities engineering modification and maintenance services for a site or platform", $row['Title']); - $unspsc[$noOilRigs] = $row['UNSPSC'];*/ + $unspsc[$noOilRigs] = $row['UNSPSC']; } //print_r($unspsc); $query = 'SELECT "CNID",lower("category") as category,"value"