Changeset 5261


Ignore:
Timestamp:
2006/09/20 14:50:24 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • temp/trunk/data/conf/conf.php

    r5260 r5261  
    856856        (SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count 
    857857        FROM dtb_category AS T1 LEFT JOIN dtb_category_total_count AS T2 
    858         ON T1.category_id = T2.category_id) vw_category_count ' 
     858        ON T1.category_id = T2.category_id) ' 
    859859); 
    860860 
  • temp/trunk/html/products/list.php

    r5260 r5261  
    352352        $objQuery = new SC_Query(); 
    353353        $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited"; 
    354         $table = "vw_product_class "; 
     354        $table = "vw_product_class AS prdcls"; 
    355355        $where = "product_id = ?"; 
    356356        $objQuery->setorder("rank1 DESC, rank2 DESC"); 
Note: See TracChangeset for help on using the changeset viewer.