Changeset 5258 for temp/trunk/html/admin/mail/inc_mailmagazine.php

Timestamp:

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

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/mail/inc_mailmagazine.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;