am: 12. November 2011, 12:26:34
Hallo
vielleicht kann mir jemand dabei helfen.
ich möchte die Kundenadresse in einer zusätzlichen Box ausgeben.
Box erstellen usw das klappt alles wunderbar, nur die Datenbankabfrage funktioniert nicht.
Hier mein Box-Code:
<?php
$box_smarty = new smarty;
$box_smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/');
$box_content='';
$box_address_query = xtc_db_query(" SELECT
customers_firstname,
customers_lastname
FROM
" . TABLE_CUSTOMERS . "
WHERE
customers_id = " . (int)$_SESSION['customer_id']);
$box_address_data = xtc_db_fetch_array($box_address_query);
$smarty->assign('NAME', $box_address_data['customers_firstname']);
$smarty->assign('VORNAME', $box_address_data['customers_lastname']);
$box_smarty->caching = 0;
$box_smarty->assign('language', $_SESSION['language']);
$box_address = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_address.html');
$smarty->assign('box_ADDRESS',$box_address);
?>
Danke für die Hilfe
Linkback: https://www.modified-shop.org/forum/index.php?topic=16665.0