Antwort #147 am: 02. Juli 2011, 14:53:08
Hallo Franky,
hatte ich natürlich zuerst probiert. Aber auch so bleiben die Felder leer.
shop_content.php die SQL-Abfrage:
$c_query = xtc_db_query("SELECT * FROM ".TABLE_CUSTOMERS." WHERE customers_id='".$_SESSION['customer_id']."'");
$c_data = xtc_db_fetch_array($c_query);
$street = $c_data['customers_street'];
$postcode = $c_data['customers_postcode'];
$city = $c_data['customers_city'];
$email_address = $c_data['customers_email_address'];
$phone= $c_data['customers_telephone'];
in
$c_query = xtc_db_query("SELECT * FROM ".TABLE_CUSTOMERS." c
LEFT JOIN ". TABLE_ADDRESS_BOOK ." ab
ON c.customers_id = ab.customers_id
WHERE c.customers_id='".$_SESSION['customer_id']."'");
$c_data = xtc_db_fetch_array($c_query);
$street = $c_data['customers_street'];
$postcode = $c_data['customers_postcode'];
$city = $c_data['customers_city'];
$email_address = $c_data['customers_email_address'];
$phone= $c_data['customers_telephone'];
geändert. Felder bleiben trotzdem leer.
Grüße hechicero