Changeset 5259 for temp/trunk/html/products

Timestamp:

2006/09/20 14:45:58 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/products

Files:

• detail.php (modified) (1 diff)
• list.php (modified) (1 diff)

temp/trunk/html/products/detail.php

@@ -140 +140 @@
 $objQuery = new SC_Query();
 // DB¤«¤é¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë¡£
-$arrRet = $objQuery->select("*", "vw_products_allclass_detail", "product_id = ?", array($tmp_id));
+$arrRet = $objQuery->select("*", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($tmp_id));
 $objPage->arrProduct = $arrRet[0];
 

temp/trunk/html/products/list.php

@@ -352 +352 @@
         $objQuery = new SC_Query();
         $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited";
-        $table = "vw_product_class";
+        $table = "vw_product_class AS prdcls";
         $where = "product_id = ?";
         $objQuery->setorder("rank1 DESC, rank2 DESC");