Changeset 18427


Ignore:
Timestamp:
2009/12/05 10:30:05 (12 years ago)
Author:
AMUAMU
Message:

#519 SQL文が間違っていた為、修正しました。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/data/class/util/SC_Utils.php

    r18400 r18427  
    789789    function sfInsertProductClass($objQuery, $arrList, $product_id , $product_class_id = "") { 
    790790        // すでに規格登録があるかどうかをチェックする。 
    791         $where = "product_id = ? AND classcategory_id1 <> 0 AND classcategory_id1 <> 0"; 
     791        $where = "product_id = ? AND classcategory_id1 <> 0 AND classcategory_id2 <> 0"; 
    792792        $count = $objQuery->count("dtb_products_class", $where,  array($product_id)); 
    793793 
     
    20302030        for($i = 0; $i < $cnt; $i++) { 
    20312031            $html.= "<tr>"; 
    2032             foreach($array[$i] as $val) { 
     2032            foreach($array[$i] as $val) { 
    20332033                $html.="<td>$val</td>"; 
    20342034            } 
     
    22232223        $town = ereg_replace("以下に掲載がない場合","",$town); 
    22242224        $data_list[0]['town'] = $town; 
    2225         $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; 
     2225        $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; 
    22262226 
    22272227        return $data_list; 
Note: See TracChangeset for help on using the changeset viewer.