Changeset 5258 for temp/trunk/html/admin

Timestamp:

2006/09/20 14:40:17 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• mail/inc_mailmagazine.php (modified) (1 diff)
• mail/preview.php (modified) (1 diff)
• products/product.php (modified) (1 diff)

temp/trunk/html/admin/mail/inc_mailmagazine.php

@@ -83 +83 @@
 
     // ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ
-    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
     $main = $conn->getAll($sql, array($list_data["main_product_id"]));
     $list_data["main"] = $main[0];
 
     // ¥µ¥Ö¾¦ÉʤξðÊó¼èÆÀ
-    $sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+    $sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
     $k = 0;
     $l = 0;

temp/trunk/html/admin/mail/preview.php

@@ -42 +42 @@
     
     // ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ
-    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
     $main = $conn->getAll($sql, array($objPage->list_data["main_product_id"]));
     $objPage->list_data["main"] = $main[0];

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

@@ -167 +167 @@
 
         if($_POST[$keyname] != "" && $_POST[$delkey] != 1) {
-            $arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass", "product_id = ?", array($_POST[$keyname])); 
+            $arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass AS allcls", "product_id = ?", array($_POST[$keyname])); 
             $arrRecommend[$i] = $arrRet[0];
             $arrRecommend[$i]['product_id'] = $_POST[$keyname];