(63行目)
アカウントの表示
$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);
↓(・・・カスタマーズテーブルよりデータを検索する際にニックネームの取得を追加)
$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_hn, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);
(続きを読む…)