"佐藤 浩(Hiroshi S
"佐藤 浩(Hiroshi S
2004年 2月 13日 (金) 18:52:53 JST
佐藤＠キャプテンです。
admin/customers.php の456行付近にある$customers_query_rawを
変更すればできるでしょう。
(修正前)
$customers_query_raw = "select c.customers_id, c.customers_lastname,
c.customers_firstname, c.customers_email_address, a.entry_country_id
from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . "
a on c.customers_id = a.customers_id and c.customers_default_address
_id = a.address_book_id " . $search . " order by c.customers_lastnam
e, c.customers_firstname";
(修正後)
$customers_query_raw = "select c.customers_id, c.customers_lastname,
c.customers_firstname, c.customers_email_address, a.entry_country_id
from (" . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . "
a on c.customers_id = a.customers_id and c.customers_default_address
_id = a.address_book_id) left join " . TABLE_CUSTOMERS_INFO . " e on
e.customers_info_id = a.customers_id " . $search . " order by e.cust
omers_info_date_account_created";
*********************************
〒990-0043 山形市本町一丁目7-54
キャプテン山形株式会社
佐藤 浩
TEL 023-622-6611
Fax 023-622-6733
E-mail: s.hir****@mmy*****
*********************************