Changeset 17603


Ignore:
Timestamp:
2008/09/09 22:12:28 (12 years ago)
Author:
Seasoft
Message:

r17599 により列が曖昧になったため明示。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php

    r17579 r17603  
    731731                . "   FROM dtb_product_categories T2  " 
    732732                . " GROUP BY product_id) AS T3 USING (product_id)"; 
    733         $objQuery->setorder("product_rank DESC"); 
     733        $objQuery->setorder("T3.product_rank DESC"); 
    734734        for($i = 0; $i < $max; $i++) { 
    735735            $where = "del_flg = 0 AND T3.product_id = ? AND status = 1"; 
    736             $arrProductInfo = $objQuery->select("DISTINCT main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate, product_rank", $from, $where, array($arrRet[$i]['recommend_product_id'])); 
     736            $arrProductInfo = $objQuery->select("DISTINCT main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate, T3.product_rank", $from, $where, array($arrRet[$i]['recommend_product_id'])); 
    737737 
    738738            if(count($arrProductInfo) > 0) { 
Note: See TracChangeset for help on using the changeset viewer.