Changeset 2019 for temp/trunk

Timestamp:

2006/08/26 10:29:16 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/products/product_class.php (modified) (1 diff)

temp/trunk/html/admin/products/product_class.php

@@ -194 +194 @@
     $col.= "product_class_id, product_id, T1_classcategory_id AS classcategory_id1, T2_classcategory_id AS classcategory_id2, ";
     $col.= "product_code, stock, stock_unlimited, sale_limit, price01, price02, status";
-    $col.= " ,(SELECT name FROM dtb_products AS prd WHERE prd.product_id = T3.product_id) ";
+    $col.= " ,(SELECT name FROM dtb_products AS prd WHERE prd.product_id = T3.product_id) as product_name";
     
     $sql = "SELECT $col FROM ";