MODUL "product_related_products_cat.php" mit Produktbild

$products_query = xtc_db_query("SELECT
							p.products_id,
							pd.products_name
							FROM 
							".TABLE_PRODUCTS_TO_CATEGORIES." pc,
							".TABLE_PRODUCTS." p,
							".TABLE_PRODUCTS_DESCRIPTION." pd
							WHERE 
							categories_id='".$cat[0]."'
							AND 
							p.products_id = pc.products_id
							AND 
							p.products_id = pd.products_id
							AND 
							pd.language_id = '".(int)$_SESSION['languages_id']."'
							AND 
							p.products_status = 1
							AND 
							p.products_id <> '".$product->data['products_id']."'
							".$fsk_lock.$group_check."
							ORDER BY RAND() LIMIT 5");


$product_related_products_cat = array();


while ($products_data = xtc_db_fetch_array($products_query, true)) {
	$product_related_products_cat[] = array(
                                    'pID' => $products_data['products_id'],
                                    'pName' => $products_data['products_name'],
                                    'prdlink' => xtc_href_link(FILENAME_PRODUCT_INFO, xtc_product_link($products_data['products_id'])));