Changeset 4847 for temp/trunk/html/admin

Timestamp:

2006/09/17 13:57:36 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/mail/index.php (modified) (2 diffs)

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

@@ -135 +135 @@
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
         $objQuery = new SC_Query();
-        $from = "dtb_customer_mail as mail LEFT OUTER JOIN dtb_customer as cus USING(email)";
+        $from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
 
         // ¹Ô¿ô¤Î¼èÆÀ
@@ -151 +151 @@
         $objQuery->setorder("customer_id DESC");
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-        $col = "cus.customer_id,cus.name01,cus.name02,cus.kana01,cus.kana02,cus.sex,cus.email,cus.tel01,cus.tel02,cus.tel03,cus.pref,mail.mail_flag";
+        $col = "dtb_customer.customer_id,
+            dtb_customer.name01,
+            dtb_customer.name02,
+            dtb_customer.kana01,
+            dtb_customer.kana02,
+            dtb_customer.sex,
+            dtb_customer.email,
+            dtb_customer.tel01,
+            dtb_customer.tel02,
+            dtb_customer.tel03,
+            dtb_customer.pref,
+            dtb_customer_mail.mail_flag";
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);