dbUpdate Associated Category Value

[amwd07]

Hello

struggling again after resolving my 1st issue all 100 categories are entered into the DB

the problem now which is stopping going further on this project is the correct category values in the DB are incorrect

 

all categories show the same value in this case 486 which is the last category Id printed from the array.

 

each subcategory should have the correct parent category  (id_xpress_cat)

but doesn't for some reason???

 

if(isset($_GET['viewsubcat'])){
foreach($this->_data['categories'] as $cat_name => $cat_count) {
  echo $cat_name."<br>";
}

  foreach($this->_data['product'] as $key => $data) {
    $xpress_cat = $data['item_category']; 
  // echo $data['item_category']."<br />";
}

  if($addcat || $updatecat) {
   $active = '1';
    if($row_xcat = dbSelect("SELECT * FROM ".WEBZSQL_DB_PREFIX."xpress_subcategory WHERE subcat_name = '".$cat_name."'",1)) {
    $id_subcat = $row_cat->id_subcat;
     if($row_xcat) {
      dbUpdate(WEBZSQL_DB_PREFIX."xpress_subcategory",array("id_xpress_cat" => $data['item_category']),' id_subcat = "'.$id_subcat.'" ');
     }

    }