$q = "SELECT products_id, color, material FROM jng_sp_catalog WHERE jng_sp_id={$jng_sp_id}"; $r = tep_db_query($q); while ($row = tep_db_fetch_array($r)) { $products_id = $row['products_id']; $ca = explode(',', $row['color']); foreach ($ca as $key => $c) { $ca[$key] = trim($c); } $color_pattern_id = array(); foreach ($ca as $c) { if ($c != '' && isset($colors[$c])) { $color_pattern_id[] = $colors[$c]; } } if (count($color_pattern_id) > 0) { $class_pm->setColorPattern($products_id, $color_pattern_id); } $ma = explode(',', $row['material']); foreach ($ma as $key => $m) { $ma[$key] = trim($m); } $products_materials_id = array(); foreach ($ma as $m) { if ($m != '' && in_array($m, $materials)) { $products_materials_id[] = array_search($m, $materials); } } if (count($products_materials_id) > 0) { $class_pm->setProductMaterials($products_id, $products_materials_id); } }