NAJA
ich bin vielleicht ein Stück dichter. Vielleicht kann ja doch noch einer was dazu sagen. Der query ist nun sicher richtig. Ich habe ihn über echo ausgegeben, wird folgend übergeben:
SELECT cd.categories_description, cd.categories_name, cd.categories_heading_title, c.listing_template, c.categories_image FROM categories c, categories_description cd WHERE c.categories_id = '0' AND cd.categories_id = '0' AND cd.language_id = '2'
Mein PhP Code ist etwas schlanker, aber trotzdem erfolgt noch immer keine Ausgabe. Kann mir vielleicht jemand helfen und mir sagen was vielleicht noch fehlt oder gar zu viel ist? Ich danke schon mal
$module_smarty = new Smarty;
$module_smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
require_once (DIR_FS_INC.'xtc_get_all_get_params.inc.php');
require_once (DIR_FS_INC.'xtc_get_vpe_name.inc.php');
$module_content = array ();
if (GROUP_CHECK == 'true') {
$group_check = "and c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
}
$category_query = "
SELECT cd.categories_description,
cd.categories_name,
cd.categories_heading_title,
c.listing_template,
c.categories_image
FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd
WHERE c.categories_id = '".$current_category_id."'
AND cd.categories_id = '".$current_category_id."".$group_check."'
AND cd.language_id = '".$_SESSION['languages_id']."'";
#echo $category_query;
$row = 0;
$module_content = array ();
$category_query = xtDBquery($category_query);
while ($category = xtc_db_fetch_array($category_query, true)) {
$module_content[] = $product->buildDataArray($category);
}
$image = '';
if ($category['categories_image'] != '')
$image = DIR_WS_IMAGES.'categories/'.$category['categories_image'];
$module_smarty->assign('CATEGORIES_NAME', $category['categories_name']);
$module_smarty->assign('CATEGORIES_HEADING_TITLE', $category['categories_heading_title']);
$module_smarty->assign('CATEGORIES_IMAGE', $image);
$module_smarty->assign('CATEGORIES_DESCRIPTION', $category['categories_description']);
if (sizeof($module_content) >= 1) {
$module_smarty->assign('language', $_SESSION['language']);
$module_smarty->assign('module_content', $module_content);
$dfcategorie_list_id = $current_category_id;
include (DIR_WS_MODULES.FILENAME_DFCATEGORIE_LIST);
// set cache ID
if (!CacheCheck()) {
$module_smarty->caching = 0;
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/dfcategorie_list.html');
} else {
$module_smarty->caching = 1;
$module_smarty->cache_lifetime = CACHE_LIFETIME;
$module_smarty->cache_modified_check = CACHE_CHECK;
$cache_id = $dfcategorie_list_id.$_SESSION['language'].
$_SESSION['customers_status']['customers_status_name'].$_SESSION['currency'];
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/dfcategorie_list.html', $cache_id);
}
$default_smarty->assign('MODULE_dfcategorie_list', $module);
}
?>
[/php]