Yepi1533005574 Posted July 27, 2018 Share Posted July 27, 2018 Hi Leute, bin gerade dabei eine neue Contrib zu schreiben mit allen relevanten Kundendaten die in der DB gespeichert werden. Diese kann der Kunde in seinem Konto alle einsehen, damit er weis, was alles gespeichert wird. Komme bei der query hier nicht weiter. Das Datum für Kontoerstellung wird ausgegeben doch alle anderen Inhalte nicht. Hab ich was übersehen ? $customers_info_query = tep_db_query("select ci.customers_id as customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified from " . TABLE_CUSTOMERS . " ci, " . TABLE_CUSTOMERS_INFO . " where customers_id = '" . (int)$customer_id . "'"); $customers_info = tep_db_fetch_array($customers_info_query); <?php echo '<h3>' . CATEGORY_SITEINFO . '</h3>' . ENTRY_TEXT_ACCOUNT_CREATED . ' ' . tep_date_short ($customers_info['customers_info_date_account_created']) . $separator . ENTRY_TEXT_AGREED_CONDITIONS . ' ' . $customers_info['customers_info_date_account_created'] . $separator . ENTRY_TEXT_LAST_LOGIN . ' ' . tep_date_short ($customers_info['customers_info_date_of_last_logon']) . $separator . ENTRY_TEXT_LOGIN_TOTAL . ' ' . $customers_info['customers_info_number_of_logons'] . $separator . '';?> Link to comment Share on other sites More sharing options...
Yepi1533005574 Posted July 28, 2018 Author Share Posted July 28, 2018 hat sich erledigt. $customers_info_query = tep_db_query("select customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, global_product_notifications from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "'"); $customers_info = tep_db_fetch_array($customers_info_query); Link to comment Share on other sites More sharing options...
Recommended Posts